I figured this out. Because I am using InnoDB, I need to add the commit statement. Phew.
Yaron Butterfield wrote: > Hi, > > I've been having problems using Python to insert data into a MySQL > database. I've donw web searches and pulled my hairs out getting it > to work but cannot. I have no trouble doing select queries, but when I > use Python to insert, though I do not receive any errors from python, > the table does not get populated. > > I've just followed the information from here by Steve Holden: > http://mail.python.org/pipermail/python-list/2005-October/302405.html > > to the tee. No errors and the same output as shown in the above > example. Yet, there isn't any data in my table. > Am I missing something so obvious?? Please help! This has frustrated > me for days now. > > regards, > Yaron > -- http://mail.python.org/mailman/listinfo/python-list
