Hello there! I got some trouble trying to insert data into the database with MySQLdb module.
I have such code: from MySQLdb import * def loc_connect_db(): """ The DB connection subroutine """ db = MySQLdb.connect(host = "localhost", user = "root", passwd="mysql", db="some_db") return db db = loc_connect_db() cursor = db.cursor() query = """insert ignore into categories (cat_id, cat_name, parent) values (%d, "%s", %d)""" % (int(CatId), CatName.capitalize(), int(parent)) print query cursor.execute(query) Queries are formed in the loop, they look fine. No errors, but no effect, records are not inserted into the table. There is my possible mistake? Any suggestions are very appreciated - Thanks in advance. Best regards, Nicolay -- http://mail.python.org/mailman/listinfo/python-list