Untitled

import sqlite3

conn=sqlite3.connect("test.db")
print("Opened database successfully");

conn.execute('''CREATE TABLE COMPANYYY
              (ID INT PRIMARY KEY NOT NULL,
               NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL);''')
conn.execute('''INSERT INTO COMPANYYY
             (ID,NAME,AGE,ADDRESS,SALARY)\
VALUES(1,'PAUL',32,"CALIFORNIA",20000.00)''');

conn.execute('''INSERT INTO COMPANYYY
             (ID, NAME, AGE, ADDRESS, SALARY) \
    VALUES(2, 'ALLEN', 25, "TEXAS", 15000.00)''');

conn.execute('''INSERT INTO COMPANYYY
             (ID, NAME, AGE, ADDRESS, SALARY) \
    VALUES(3, 'TEDDY', 23, "NORWAY", 20000.00)''');

conn.execute('''INSERT INTO COMPANYYY
             (ID, NAME, AGE, ADDRESS, SALARY) \
    VALUES(4, 'MARK', 25, "RICH-MOND", 65000.00)''');


conn.commit()
print("records created successfully")
conn.close()