sqlite.py

import sqlite3

## Connectt 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(NAME VARCHAR(25),CLASS VARCHAR(25),
SECTION VARCHAR(25),MARKS INT);

"""
cursor.execute(table_info)

## Insert Some more records

cursor.execute('''Insert Into STUDENT values('Shiv','Data Science','A',90)''')
cursor.execute('''Insert Into STUDENT values('Ritam','Data Science','B',100)''')
cursor.execute('''Insert Into STUDENT values('Upendra','Data Science','A',86)''')
cursor.execute('''Insert Into STUDENT values('Aakash','Software Engineering','A',50)''')
cursor.execute('''Insert Into STUDENT values('Raushan','Software Engineering','A',35)''')
cursor.execute('''Insert Into STUDENT values('Roopak','Web 3','B',80)''')
cursor.execute('''Insert Into STUDENT values('Atishay','Web 3','A',75)''')

## Disspaly ALl the records

print("The isnerted records are")
data=cursor.execute('''Select * from STUDENT''')
for row in data:
    print(row)

## Commit your changes int he databse
connection.commit()
connection.close()