N
Nicolay A. Vasiliev
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
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