I'm getting some wierd commit-related behavior from MySQLdb.  I'm
using InnoDB, so transactions really matter.

I'm currently doing

        cursor = db.cursor()                                    
        cursor.execute(...)
        cursor.close()                                                  
        db.commit()     

Is that the correct order, or should I call "db.commit()" before 
"cursor.close()"?  Does anyone know for sure?  The MySQLdb documentation
("http://mysql-python.sourceforge.net/MySQLdb.html";) doesn't
say.  There are some discussions of this in blogs, but nobody
really seems to know.

                                        John Nagle                              
                
-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to