import sqlite3
conn=sqlite3.connect('test.db')
cursor=conn.cursor()
cursor.execute("create table emp3(id integer,name tect)")
cursor.execute("\n insert into emp3(id,name)values(101,'ravi')")
cursor.execute("\n insert into emp3(id,name)values(102,'raju')")
cursor.execute("\n insert into emp3(id,name)values(103,'ramesh')")
print("\n displayng the table")
cursor.execute("select *from emp3")
rows=cursor.fetchall()
for row in rows:
    print(row)
print("\n after update and delete records in the table table")
cursor.execute("\n update emp3 set name='rakesh' where id=101")
cursor.execute("\n delete from emp3 where id=103")
print("\n displayng the table")
cursor.execute("select *from emp3")
rows=cursor.fetchall()
for row in rows:
    print(row)
print("\n table is droped...")
cursor.execute("drop table emp3")
conn.commit()
cursor.close()
conn.close()