擅长:python、mysql、java
<blockquote>
<p>Now, I recreate a table the same as prev one. In script, no error was reported, but in actually no data is inserted. In command line, insert sql works perfect.</p>
</blockquote>
<p>如果使用像InnoDB这样的事务引擎,则不会保存数据,因为MySqlDb默认为auto commit off。要将数据实际保存到数据库,必须调用commit</p>
<pre><code>conn = mdb.connect(user = 'root', passwd = '[REMOVED]', db = 'vancl')
cur = conn.cursor()
sql2 = "insert into vancl.vancl_query1(product_code) values('100000')"
print sql2
cur.execute(sql2)
//Commit the data
conn.commit()
cur.close()
</code></pre>