Question: Write Python program that connects to a sqlite database. Create table called Horses with the following fields: id (integer): a primary key and not null
Write Python program that connects to a sqlite database.
Create 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')
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
