File size: 902 Bytes
7e8eba4 | 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 32 33 34 35 36 | import sqlite3
## connect to sqlite
connection=sqlite3.connect("student.db")
## create a cursor object to inset record,create table
cursor = connection.cursor()
## create the table
table_info="""
create table Student(
Name varchar(50),
Class varchar(25),
Section varchar(25),
Mark int
);
"""
cursor.execute(table_info)
## insert some records
cursor.execute('''insert into Student values('Test1','DS','A',99)''')
cursor.execute('''insert into Student values('Test2','DS','B',95)''')
cursor.execute('''insert into Student values('Test3','DS','C',90)''')
cursor.execute('''insert into Student values('Test4','DO','A',80)''')
cursor.execute('''insert into Student values('Test5','DO','B',85)''')
## Display all the records
print("The inserted records are")
data = cursor.execute('''Select * from Student''')
for row in data:
print(row)
connection.commit()
connection.close() |