File size: 992 Bytes
011f2dc |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
import sqlite3
## Connect to SQlite
connection=sqlite3.connect('student.db')
## Create a cursor object to insert record, create table
cursor=connection.cursor()
## Create the table
table_info="""
Create table STUDENT(NAME VARCHAR(25), CLASS VARCHAR(25), SECTION VARCHAR(25), MARKS INT);
"""
cursor.execute(table_info)
## Insert some records
cursor.execute('''Insert Into STUDENT values('Chris','Data Science', 'A', 91)''')
cursor.execute('''Insert Into STUDENT values('Ashley','Data Science', 'B', 86)''')
cursor.execute('''Insert Into STUDENT values('Alex','Data Science', 'A', 99)''')
cursor.execute('''Insert Into STUDENT values('Doris','Software Development', 'A', 71)''')
cursor.execute('''Insert Into STUDENT values('Wong','Software Development', 'B', 52)''')
## Display all the records
print("The inserted records are:")
data=cursor.execute('''Select * from STUDENT''')
for row in data:
print(row)
## Commit the changes in the database
connection.commit()
connection.close() |