|
import sqlite3
|
|
|
|
|
|
connection=sqlite3.connect("COMPANY.db")
|
|
|
|
|
|
|
|
cursor=connection.cursor()
|
|
|
|
|
|
table_info="""
|
|
Create table COMPANY(FIRST_NAME VARCHAR(25),LAST_NAME VARCHAR(25),DEPT VARCHAR(25),
|
|
SALARY VARCHAR(25),AGE INT);
|
|
|
|
"""
|
|
cursor.execute(table_info)
|
|
|
|
|
|
|
|
cursor.execute('''Insert Into COMPANY values('Jaya', 'Chandran','Data Science','$1000',35)''')
|
|
cursor.execute('''Insert Into COMPANY values('Karthy','R','DEVOPS','$900',33)''')
|
|
cursor.execute('''Insert Into COMPANY values('Anbu', 'Alagan','AEM','$800',33)''')
|
|
cursor.execute('''Insert Into COMPANY values('Sivam','Sivam','DEVOPS','$1000',30)''')
|
|
cursor.execute('''Insert Into COMPANY values('Mani','Ratam','Data Science','$500',20)''')
|
|
cursor.execute('''Insert Into COMPANY values('Kasi','Nathan','Security','$400',23)''')
|
|
cursor.execute('''Insert Into COMPANY values('Ravi','Kumar','.Net','$150',25)''')
|
|
|
|
|
|
|
|
print("The inserted records are")
|
|
data=cursor.execute('''Select * from COMPANY''')
|
|
for row in data:
|
|
print(row)
|
|
|
|
|
|
connection.commit()
|
|
connection.close()
|
|
|