Python操作sqllite3

Python操作sqllite3

import sqlite3 #操作Sqlite3 con=sqlite3.connect(r"F:\baidu download\test.db") cour=con.cursor() # cour.execute("create table mytab(id integer primary key autoincrement not null,name text,passwd text)") # cour.execute("insert into mytab(name,passwd) values(?,?)",("bobo","4565892",)) # cour.executemany("insert into mytab(name,passwd) values(?,?)",[("dao","123"),("liming","654"),("fsdfsdf","65656")],) # print('显示记录') # cour.execute("select * from mytab") # for k,v,d in cour: # print(k,v,d) # print("更新一条记录") # cour.execute("update mytab set name=? where id=?",("aaa",1)) # print("显示所有记录") # cour.execute("select * from mytab") # for item in cour.fetchall(): # print(item) # # cour.execute("delete from mytab where id=?",(1,)) # print("显示所有记录") # cour.execute("select * from mytab") # for q,w,e in cour: # print(q,w,e) cour.close() con.close()

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。