python sqlite 增删改查 操作

from sqlite3 import connect conn = connect('dbase1') curs = conn.cursor() try: curs.execute('drop table people') except: pass # did not exist curs.execute('create table people (name char(30), job char(10), pay int(4))')

curs.execute('insert into people values (?, ?, ?)', ('Bob', 'dev', 50000)) curs.execute('insert into people values (?, ?, ?)', ('Sue', 'dev', 60000))

curs.execute('select * from people') for row in curs.fetchall(): print(row)

curs.execute('select * from people') colnames = [desc[0] for desc in curs.description] while True: print('-' * 30) row = curs.fetchone() if not row: break for (name, value) in zip(colnames, row): print('%s => %s' % (name, value))

conn.commit() # save inserted records

把TXT文件中的数据插入数据库

image.png