Details
DAT/210 Week 5 Python LAB 6.22: Python and sqlite basics
Write a Python program that connects to a sqlite database.
Create a table called Horses with the following fields:
• id (integer): a primary key and not null
• name (text)
• breed (text)
• height (real)
• birthday (text)
Next, insert the following data row into the Horses table:
id: 1
name: 'Babe'
breed: 'Quarter Horse'
height: 15.3
birthday: '2015-02-10'
Output all records from the Horses table.
Ex: With the above row inserted, the output should be:
All Horses:
(1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10')
Additional Information
| Special Price | $4.00 |
|---|
Check items to add to the cart or select all
-
-
DAT/210 Week 5 Python LAB 6.20: Output values in a list below a user defined amount
Add to WishlistRegular Price:
Special Price
-
DAT/210 Week 5 Python 6.23: Python insert/update sqlite3 datafiles
Add to WishlistRegular Price:
Special Price
You have no items in your shopping cart.
