HI,

I'm having trouble writing to a MySql db using python and the MySQLdb
module. Here is the code:

import MySQLdb
base = MySQLdb.connect(host="localhost", user="blah", passwd="blah",
db="test_py")
cursor = base.cursor()
cursor.execute("INSERT INTO table (field) VALUES (int)")

this does not work but the interesting thing is, there is an
AUTO_INCREMENT
field. Now say i had a couple of entries in there already:
                                   auto  table
                                    1    |    90
                                    2    |    32

and then i run my py script 3 times, the data is not entered but if i
add
another entry from mysql the auto increment field will have counted the

python entries:
                       auto    table
                         1    |    90
                         2    |    32
                         6    |    47

please tell me what i am doing wrong. thanks.

-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to