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