import sqlite3
conn = sqlite3.connect('t1.db')
cursor = conn.cursor()
conn.execute("DELETE from user")
cursor.execute('insert into user (id, name) values ('1', '张三')')
cursor.execute('insert into user (id, name) values ('2', '李四')')
cursor.execute('insert into user (id, name) values ('3', '王二')')
cursor.execute('insert into user (id, name) values ('4', '刘五')')
conn.commit()
cursor.execute('select id,name from user')
values = cursor.fetchone()
values = cursor.fetchone()
print(values)
cursor.close()
conn.close()