evd和dvd的区别,尼古拉斯凯奇新电影,叶落长安全集在线观看
本文实例讲述了Python简单操作sqlite3的方法。分享给大家供大家参考,具体如下:
import sqlite3 def Test1(): #con =sqlite3.connect("D:\\test.db") con =sqlite3.connect(":memory:") #store in memory cur =con.cursor() try: cur.execute('create table score(id integer primary key,name varchar(10),scores integer)') cur.execute("insert into score values(0,'Rose',87)") cur.execute("insert into score values(1,'Alice',78)") cur.execute("insert into score values(2,'Helon',100)") cur.execute("insert into score values(3,'Tom',98)") cur.execute("insert into score values(4,'jack',198)") cur.execute("insert into score values(5,'Tony',198)") cur.execute("insert into score values(6,'David',99)") cur.execute("update score set scores =? where id=?",(45,3)) cur.execute("update score set name=? where id=?",("John",0)) cur.execute("delete from score where id =1") except Exception,e: print "There are some except",e con.commit() print "Insert Complete" print "-----------------------------------------" print "Last row id is ",cur.lastrowid cur.execute('select * from score') print cur.fetchall() print "----------------------------------------" cur.execute("select count(*) from score") print "Current Rows is :",cur.fetchall()[0] cur.close() con.close() if __name__ =='__main__': Test1() print "hello world"
更多关于Python相关内容感兴趣的读者可查看本站专题:《》、《》、《》、《》、《》、《》、《》、《》及《》
希望本文所述对大家Python程序设计有所帮助。
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
Python 实现将numpy中的nan和inf,nan替换成对应的均值
python爬虫把url链接编码成gbk2312格式过程解析
网友评论