Python, Mysql, insert NULL

[Yaron Butterfield]

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
>