Python, Mysql, insert NULL

Yaron Butterfield yaronb at
Thu May 18 22:39:54 CEST 2006

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:
> 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

More information about the Python-list mailing list