python 执行sqlite输入插入操作后获得自动编号的ID
想sqlite插入一条记录后,马上获得自动生成的id编号的方法
1 2 3 4 5 6 7 8 9 10 |
connection=sqlite3.connect(':memory:') cursor=connection.cursor() cursor.execute('''CREATE TABLE foo (id integer primary key autoincrement , username varchar(50), password varchar(50))''') cursor.execute('INSERT INTO foo (username,password) VALUES (?,?)', ('test','test')) print(cursor.lastrowid) #该代码片段来自于: http://www.sharejs.com/codes/python/2328 |
