import sqlite3
conn=sqlite3.connect('test.db')
cursor=conn.cursor()
cursor.execute("create table emp1(id integer,name text)")
cursor.execute(("insert into emp1(id,name)values(101,'ravi')"))
cursor.execute(("insert into emp1(id,name)values(102,'ravishankar')"))
cursor.execute(("insert into emp1(id,name)values(103,'ramesh')"))
print("\n Displaying the employee1 table")
cursor.execute("select * from emp1")
rows=cursor.fetchall()
for row in rows:
    print(row)
print("\n after update and delete the record in the table")
cursor.execute("update emp1 set name='Rakesh' where id=101")
cursor.execute("delete from emp1 where id=103")
print("Displaying emp1 table")
cursor.execute("select * from emp1")
rows=cursor.fetchall()
for row in rows:
    print(row)
print("\n Table is droped...")
cursor.execute("drop table emp1")
conn.commit;
cursor.close()
conn.close()