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


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

