space-runner/DBChatingApp

1import sqlite3 2 3 4connection= sqlite3.connect("student.db")5 6cursor = connection.cursor()7 8table_info = """9Create table STUDENT(NAME VARCHAR(25),CLASS VARCHAR(25),10SECTION VARCHAR(25));11"""12 13 14cursor.execute(table_info)15 16 17# Inserting Some more records18 19 20cursor.execute('''Insert Into STUDENT values('Faraz', 'Computer Science', 'A')''')21cursor.execute('''Insert Into STUDENT values('Alice', 'Mathematics', 'B')''')22cursor.execute('''Insert Into STUDENT values('Bob', 'Physics', 'C')''')23cursor.execute('''Insert Into STUDENT values('Charlie', 'Chemistry', 'A')''')24cursor.execute('''Insert Into STUDENT values('David', 'Biology', 'B')''')25cursor.execute('''Insert Into STUDENT values('Ella', 'Computer Science', 'A')''')26cursor.execute('''Insert Into STUDENT values('Frank', 'Mathematics', 'C')''')27cursor.execute('''Insert Into STUDENT values('Grace', 'Physics', 'B')''')28cursor.execute('''Insert Into STUDENT values('Hannah', 'Chemistry', 'A')''')29cursor.execute('''Insert Into STUDENT values('Ivy', 'Biology', 'C')''')30cursor.execute('''Insert Into STUDENT values('Jack', 'Computer Science', 'A')''')31cursor.execute('''Insert Into STUDENT values('Kate', 'Mathematics', 'B')''')32cursor.execute('''Insert Into STUDENT values('Liam', 'Physics', 'A')''')33cursor.execute('''Insert Into STUDENT values('Mia', 'Chemistry', 'C')''')34cursor.execute('''Insert Into STUDENT values('Noah', 'Biology', 'B')''')35cursor.execute('''Insert Into STUDENT values('Olivia', 'Computer Science', 'A')''')36cursor.execute('''Insert Into STUDENT values('Peter', 'Mathematics', 'C')''')37cursor.execute('''Insert Into STUDENT values('Quinn', 'Physics', 'B')''')38cursor.execute('''Insert Into STUDENT values('Rose', 'Chemistry', 'A')''')39cursor.execute('''Insert Into STUDENT values('Sam', 'Biology', 'C')''')40 41 42 43# Display all the records44 45print("The inserted records are")46data = cursor.execute('''Select * from STUDENT''')47for row in data:48    print(row)49    50connection.commit()51connection.close()