Problem With Insert with MySQLdb

Steve Horsley steve.horsley at gmail.com
Mon Oct 31 21:37:39 CET 2005


David Mitchell wrote:
> Hello,
> 
> I am a complete beginner with Python. I've managed to get mod_python up and
> running with Apache2 and I'm trying to a simple insert into a table in a
> MySQL database. 
> 
> I'm using the MySQLdb library for connectivity. I can read from the database
> no problem, but when I do an insert, the value never gets added to the
> database, even though there is no error, and the SQL is fine (I print out
> the SQL statement in the function). When I copy and paste the sql from my
> browser and insert directly into MySQL, it works fine.
> 
> Here is the function in question:
> 
> def add(req):
> 	db = MySQLdb.connect(host="intranet", user="root", passwd="",
> db="intranet")
> 	# create a cursor
> 	cursor = db.cursor()
> 	# execute SQL statement
> 	
> 	sql = "INSERT INTO category (category_name) VALUES ('" +
> req.form['category'] + "')"
> 	cursor.execute(sql)
> 	return sql
> 
> 
> The SQL it is outputting is:
> 
> INSERT INTO category (category_name) VALUES ('Test')
> 
> Am I doing something obviously incorrect here?
> 
> Thanks,
> 
> Dave
> 

Try either executing this first:
     cursor.execute("set autocommit = 1")
or this afterwards:
     cursor.execute("commit")

The idea is that transactions are not committed into the database 
until you "commit" them - and if you hit problems halfway through 
a sequence of updates that really shouldn't be left half 
finished, you can execute "abort" instead (or just close the 
connection), and none of them will be done.

Steve



More information about the Python-list mailing list