File size: 1,318 Bytes
d1f1644 |
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
# Establish a connection 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_INFO(NAME VARCHAR(25), CLASS VARCHAR(25),
SECTION VARCHAR(25));
"""
cursor.execute(table_info)
# Insert Some more records
cursor.execute('''Insert Into STUDENT_INFO values('Ashish', 'Data Scientist', 'A')''')
cursor.execute('''Insert Into STUDENT_INFO values('Devesh', 'Software Developer', 'A')''')
cursor.execute('''Insert Into STUDENT_INFO values('Tanuja', 'Cyber Security', 'A')''')
cursor.execute('''Insert Into STUDENT_INFO values('Hardeep', 'UX Design', 'A')''')
cursor.execute('''Insert Into STUDENT_INFO values('Rahul', 'Data Analyst', 'A')''')
cursor.execute('''Insert Into STUDENT_INFO values('Pawan', 'Data Scientist', 'A')''')
cursor.execute('''Insert Into STUDENT_INFO values('Neeraj', 'Backend Developer', 'A')''')
cursor.execute('''Insert Into STUDENT_INFO values('Neeraja', 'Data Scientist', 'A')''')
# Display All the records
print("The Inserted records are")
data=cursor.execute('''Select * from STUDENT_INFO''')
for row in data:
print(row)
# Commit your changes in the Database
connection.commit()
connection.close() |