Re: [DB-SIG] Question about MySQL insert function

2006-08-08 Thread Andy Dustman
On 7/30/06, Chris Curvey <[EMAIL PROTECTED]> wrote: > Just wondering...do you need to commit() ? He does. Autocommit is off by default, as specified by PEP-249. -- The Pythonic Principle: Python works the way it does because if it didn't, it wouldn't be Python. ___

Re: [DB-SIG] Question about MySQL insert function

2006-07-30 Thread Chris Curvey
Just wondering...do you need to commit() ?On 7/30/06, Kiwi Golf <[EMAIL PROTECTED]> wrote: Dear all,Following is the example code I tried. I got a problem that the table iscreated however the data can not insert into MySQL server. Any idea how tofix this?Thank you very much!Chloe --

Re: [DB-SIG] Question about MySQL insert function

2006-07-30 Thread Andy Todd
Kiwi Golf wrote: > Hi Andy, > > I run the code (.py) without any error message however when I go back to > MySQL server, and try to check whether the data was inserted into MySQL, > I got empty set from the db. My system is Python 2.4, MySQL 5.0, and > MySQLdb(MySQL-python.exe-1.2.1_p2.win32-py

Re: [DB-SIG] Question about MySQL insert function

2006-07-30 Thread Andy Todd
Kiwi Golf wrote: > Dear all, > > Following is the example code I tried. I got a problem that the table is > created however the data can not insert into MySQL server. Any idea how to > fix this? > > Thank you very much! > Chloe > > import sys > impor