import sqlite3 conn = sqlite3.connect('mrsoft.db') cursor = conn.cursor() cursor.execute('create table user(id int(10) primary key,name varchar(2))') cursor.close() conn.close()
************************************************
import sqlite3 conn = sqlite3.connect('mrsoft.db') cursor = conn.cursor() sql = 'insert into user(id,name) values(?,?)' # cursor.execute(sql,(2,"xiaoming")) data=[(3,"andy"),(4,"tom"),(5,"jordon")] cursor.executemany(sql,data) cursor.close() conn.commit() conn.close()
*************************************************** import sqlite3 conn = sqlite3.connect('mrsoft.db') cursor = conn.cursor() sql = 'select * from user' cursor.execute(sql) # result = cursor.fetchone() # print(result) # result = cursor.fetchone() # print(result) # result =cursor.fetchmany(3) result = cursor.fetchall() print(result) cursor.close() # conn.commit() conn.close()
**********************************************************
import sqlite3 conn = sqlite3.connect('mrsoft.db') cursor = conn.cursor() sql = 'update user set name=? where id=?' cursor.execute(sql,("mr",1)) cursor.execute("select * from user") result = cursor.fetchall() print(result) cursor.close() conn.commit() conn.close()
******************************************************************
import sqlite3 conn = sqlite3.connect('mrsoft.db') cursor = conn.cursor() sql = 'delete from user where id=?' cursor.execute(sql,(1,)) cursor.execute("select * from user") result = cursor.fetchall() print(result) cursor.close() conn.commit() conn.close()