擅长:python、mysql、java
<p>首先,您需要在<em>游标</em>上执行命令,而不是连接本身。其次,您需要提交事务:</p>
<pre><code>import sqlite3
db = sqlite3.connect('test.db')
db.row_factory = sqlite3.Row
cur = db.cursor() # getting a cursor
cur.execute('drop table if exists test')
cur.execute('create table test (t1 text,i1 text)')
db.commit() # commit the transaction, note commits are done
# at the connection, not on the cursor
cur.execute('insert into test (t1, i1) values (?, ?)',('xyzs','51'))
db.commit()
cursor = cur.execute('select * from test')
for row in cursor:
print(row['t1'],row['i1'])
</code></pre>
<p>请看一下<a href="http://docs.python.org/2/library/sqlite3.html" rel="nofollow">documentation</a>。一旦您开始使用Python中的其他数据库,这将对您有所帮助,因为它们都遵循相同的API。你知道吗</p>