sqlite.py

import sqlite3



## Connect to Sqlite3 database

connection=sqlite3.connect("student.db")

# Create a cursor object to insert record or create table 


cursor=connection.cursor()


#create the table 


table__info="""
Create table STUDENT(NAME VARCHAR(25), CLASS VARCHAR(25), SECTION VARCHAR(25));
"""
print(table__info)



cursor.execute(table__info)

##Insert Some more Records into the table

cursor.execute("Insert Into STUDENT values('Rahul','Data Science','A')")
cursor.execute("Insert Into STUDENT values('Akshay','Science','D')")
cursor.execute("Insert Into STUDENT values('Pankaj','Gaming','B')")
cursor.execute("Insert Into STUDENT values('Darius','Devops','A')")
cursor.execute("Insert Into STUDENT values('Dipesh','Devops','A')")

##Display all the records from the table

print("The inserted records are :")

data=cursor.execute('''Select * from STUDENT''')


for row in data:
    print(row)


 ## COmmit your changes to the database

connection.commit()
connection.close()