MySQLdb not INSERTING, _mysql does fine

Question

Okay, I log onto the MySQL command-line client as root. I then open or otherwise run a python app using the MySQLdb module as root. When I check the results using python (IDLE), everything looks fine. When I use the MySQL command-line client, no INSERT has occurred. If I change things around to _mysql instead of MySQLdb, everything works fine. I'd appreciate any clarification(s).

"Works" until IDLE/Virtual machine is reset:

import MySQLdb
db = MySQLdb.connect(user='root', passwd='*******',db='test')
cursor = db.cursor()
cursor.execute("""INSERT INTO test VALUES ('somevalue');""",)

Works:

import _mysql
db = _mysql.connect(user='root', passwd='*******',db='test')
db.query("INSERT INTO test VALUES ('somevalue');")

System info: Intel x86 WinXP Python 2.5 MySQL 5.1.41 MySQL-Python 1.2.2

zoli2k · Accepted Answer · 2010-04-07 07:03:36Z

17

You can use db.commit() to submit data or set db.autocommit() after _mysql.connect(...) to autocommit requests.

answered Apr 7, 2010 at 7:03

zoli2k

3,5284 gold badges28 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

armani Over a year ago

This worked for me, thanks for posting it (almost 3 years ago)!

Michael Aquilina Over a year ago

This is exactly what I was looking for. Funnily enough most tutorials do not mention this which surprises me.

Yaroslav · Accepted Answer · 2010-04-07 06:50:11Z

4

I think they use different autocommit settings. Use commit() after inserting data.

answered Apr 7, 2010 at 6:50

Yaroslav

2,73617 silver badges16 bronze badges

Collectives™ on Stack Overflow

MySQLdb not INSERTING, _mysql does fine

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related