详解python中executemany和序列的使用方法
详解python中executemany和序列的使用方法
一代码
importsqlite3 persons=[ ("Jim","Green"), ("Hu","jie") ] conn=sqlite3.connect(":memory:") conn.execute("CREATETABLEperson(firstname,lastname)") conn.executemany("INSERTINTOperson(firstname,lastname)VALUES(?,?)",persons) forrowinconn.execute("SELECTfirstname,lastnameFROMperson"): print(row) print("Ijustdeleted",conn.execute("DELETEFROMperson").rowcount,"rows")
二运行结果
y======== ('Jim','Green') ('Hu','jie') Ijustdeleted2rows
以上就是python中executemany和序列的应用,如有疑问请留言或者到本站社区交流讨论,感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!