擅长:python、mysql、java
<p>我不确定,如果您只想设置列的on作为主键,那么我建议使用这种语法。你知道吗</p>
<pre><code> # Creating a second table with 1 column and set it as PRIMARY KEY
# note that PRIMARY KEY column must consist of unique values!
c.execute('CREATE TABLE {tn} ({nf} {ft} PRIMARY KEY)'\
.format(tn=table_name2, nf=new_field, ft=field_type))
</code></pre>
<p>您可以看到这个例子<a href="https://github.com/rasbt/python_reference/blob/master/tutorials/sqlite3_howto/code/create_new_db.py" rel="nofollow">here</a></p>