Spaces:
Sleeping
Sleeping
File size: 2,359 Bytes
151368f |
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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 |
import sqlite3
## conect the sql
connection = sqlite3.connect("student.db")
# Create a cursor object to insert record, craete table, retreeve
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)
# inser some more recordes
cursor.execute('''Insert into STUDENT values('Nasir','data Science', 'A', 90)''')
cursor.execute('''Insert into STUDENT values('Akhtar','Generative AI', 'B', 87)''')
cursor.execute('''Insert into STUDENT values('Asad','DEVOPS', 'A', 83)''')
cursor.execute('''Insert into STUDENT values('Munawer','data Science', 'C', 93)''')
cursor.execute('''Insert into STUDENT values('Muzafar','Generative AI', 'A', 83)''')
cursor.execute('''Insert into STUDENT values('Ali','DEVOPS', 'C', 82)''')
cursor.execute('''Insert into STUDENT values('Kashif','data Science', 'A', 79)''')
cursor.execute('''Insert into STUDENT values('Aneela','DEVOPS', 'B', 81)''')
cursor.execute('''Insert into STUDENT values('Danish','data Science', 'A', 78)''')
cursor.execute('''Insert into STUDENT values('Rabia','DEVOPS', 'C', 82)''')
cursor.execute('''Insert into STUDENT values('Khizar','Generative AI', 'A', 76)''')
cursor.execute('''Insert into STUDENT values('Nazia','data Science', 'A', 73)''')#
cursor.execute('''Insert into STUDENT values('Bilal','Generative AI', 'B', 72)''')
cursor.execute('''Insert into STUDENT values('sajid','DEVOPS', 'A', 87)''')
cursor.execute('''Insert into STUDENT values('Asif','data Science', 'C', 63)''')
cursor.execute('''Insert into STUDENT values('Husnain','Generative AI', 'A', 98)''')
cursor.execute('''Insert into STUDENT values('Hamza','DEVOPS', 'C', 84)''')
cursor.execute('''Insert into STUDENT values('Ikram','data Science', 'A', 65)''')
cursor.execute('''Insert into STUDENT values('Ramzan','DEVOPS', 'B', 78)''')
cursor.execute('''Insert into STUDENT values('Abid','data Science', 'A', 72)''')
cursor.execute('''Insert into STUDENT values('Jafir','DEVOPS', 'C', 81)''')
cursor.execute('''Insert into STUDENT values('Sadiq','Generative AI', 'A', 92)''')
## Display all the recards
print("The inserted recards are")
data = cursor.execute('''Select * From STUDENT''')
for row in data:
print(row)
# close the connection
connection.commit()
connection.close() |