| import sqlite3
|
|
|
|
|
| connection=sqlite3.connect("student.db")
|
|
|
|
|
| cursor=connection.cursor()
|
|
|
|
|
| table_info = """
|
| CREATE TABLE STUDENT_INFO(NAME VARCHAR(25), CLASS VARCHAR(25),
|
| SECTION VARCHAR(25));
|
| """
|
|
|
| cursor.execute(table_info)
|
|
|
|
|
| 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')''')
|
|
|
|
|
|
|
| print("The Inserted records are")
|
| data=cursor.execute('''Select * from STUDENT_INFO''')
|
| for row in data:
|
| print(row)
|
|
|
|
|
| connection.commit()
|
| connection.close() |
