current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 2 down vote favorite

I'm trying to figure out how to use the MySQLdb library in python (I am novice at best for both of them).

I'm following the code here: http://www.kitebird.com/articles/pydbapi.html

Specifically:

cursor = conn.cursor ()
cursor.execute ("DROP TABLE IF EXISTS animal")
cursor.execute ("""
   CREATE TABLE animal
   (
     name     CHAR(40),
     category CHAR(40)
   )
 """)
cursor.execute ("""
   INSERT INTO animal (name, category)
   VALUES
     ('snake', 'reptile'),
     ('frog', 'amphibian'),
     ('tuna', 'fish'),
     ('racoon', 'mammal')
 """)
print "Number of rows inserted: %d" % cursor.rowcount
cursor.close ()
conn.close ()

I have poked around it, and can get it to create tables or drop tables by changing the basic code, but I can't get it to actually commit the INSERT. It returns the row.count value as expected (even when I change the value table, it changes to what I expect it to be).

Everytime I look into the db (via PHPMyAdmin) there are no inserts made.

Can anyone point me in the right direction?

share|improve this question

1 Answer 1

up vote 9 down vote accepted

You forget commit data changes, autocommit is disabled by default:

   cursor.close ()
   conn.commit ()
   conn.close ()

Quoting Writing MySQL Scripts with Python DB-API documentation:

"The connection object commit() method commits any outstanding changes in the current transaction to make them permanent in the database. In DB-API, connections begin with autocommit mode disabled, so you must call commit() before disconnecting or changes may be lost."

share|improve this answer
    
Aw man. Thank you. Thats a lesson I won't forget again! Of course, that works. (And I had all the clues in my question! sigh.) –  Jay Gattuso Feb 7 '12 at 8:35
    
@JayGattuso, you are right, your question contains the answer: "but I can't get it to actually commit the INSERT" –  danihp Feb 7 '12 at 8:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.