| import sqlite3 |
|
|
| |
| connection =sqlite3.connect("student.db") |
|
|
| |
|
|
| cursor=connection.cursor() |
|
|
|
|
|
|
| |
| table_info=""" |
| create table STUDENT(NAME VARCHAR(25), CLASS VARCHAR(25), |
| SECTION VARCHAR(25)); |
| |
| """ |
|
|
| |
|
|
| cursor.execute(table_info) |
| |
|
|
| cursor.execute("""Insert into STUDENT values('Krish','Software Engineering', 'A')""") |
| cursor.execute("""Insert into STUDENT values('Topister','Data Science', 'B')""") |
| cursor.execute("""Insert into STUDENT values('Onyango','Data Science', 'A')""") |
| cursor.execute("""Insert into STUDENT values('Nandera','Data Science', 'B')""") |
| |
| |
| print("The inserted records are") |
| data=cursor.execute("""Select * from STUDENT""") |
| for row in data: |
| print(row) |
|
|
|
|
| connection.commit() |
| connection.close() |
