这篇文章主要介绍了 python 操作 sqlite 的 CRUD 实现方法, 涉及 Python 操作 SQLite 数据库 CURD 相关技巧, 需要的朋友可以参考下
本文实例讲述了 python 操作 sqlite 的 CRUD 实现方法分享给大家供大家参考具体如下:
- import sqlite3 as db
- conn = db.connect('mytest.db')
- cursor = conn.cursor()
- cursor.execute("drop table if exists datecounts")
- cursor.execute("create table datecounts(date text, count int)")
- cursor.execute('insert into datecounts values("12/1/2011",35)')
- cursor.execute('insert into datecounts values("12/2/2011",42)')
- cursor.execute('insert into datecounts values("12/3/2011",38)')
- cursor.execute('insert into datecounts values("12/4/2011",41)')
- cursor.execute('insert into datecounts values("12/5/2011",40)')
- cursor.execute('insert into datecounts values("12/6/2011",28)')
- cursor.execute('insert into datecounts values("12/7/2011",45)')
- conn.row_factory = db.Row
- cursor.execute("select * from datecounts")
- rows = cursor.fetchall()
- for row in rows:
- print("%s %s" % (row[0], row[1]))
- cursor.execute("select avg(count) from datecounts")
- row = cursor.fetchone()
- print("The average count for the week was %s" % row[0])
- cursor.execute("delete from datecounts where count = 40")
- cursor.execute("select * from datecounts")
- rows = cursor.fetchall()
- for row in rows:
- print("%s %s" % (row[0], row[1]))
希望本文所述对大家的 Python 程序设计有所帮助
来源: https://www.php1.cn/detail/php-ee1add0c62.html