python操作sqlite的CRUD,pythonsqlitecrud,import sqlit
文章由Byrx.net分享于2019-03-23 09:03:22
python操作sqlite的CRUD,pythonsqlitecrud,import sqlit
import sqlite3 as dbconn = 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.Rowcursor.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]))
相关内容
- Ubuntu,按下ctrl,查询选定的单词,ubuntuctrl,双击或拖选
- Python从URL地址提取文件名,,import osurl
- python从mymailbox.msg获取邮件信息,,import rfc82
- python中访问类的docstring注释的方法,pythondocstring,class
- python一句代码实现全排列,python一句代码,from itertoo
- PyQt界面中用twisted建立server,pyqttwistedserver,这两天在看
- 用pyui4win给python添加动画界面,,这是用开源项目pyui4
- 使用python下载网页上的flash,pythonflash,'''Created o
- Python 兔子毒药问题,python兔子毒药,大致是这样的:1
- python对字典进行排序,python字典排序,1、 准备知识:在
评论关闭