Solved: Python MySQLdb Insert Statements Not Saving

So it turns out that if you are using MyISAM as your MySQL engine, you just need to do a simple:

conn = MySQLdb.connect("""CONNECT ARGS""")
cursor.execute(""" INSERT COMMANDS """)

And everything will be OK.

If, however, you decide to use InnoDB (which you probably should) or if for some reason you find that your INSERT commands are not saving you need to do the following...

conn = MySQLdb.connect("""CONNECT ARGS""")
cursor.execute(""" INSERT COMMANDS """)
conn.commit()
 

Here's a good explanation of how it all works if you just can't seem to be getting it right:

http://www.kitebird.com/articles/pydbapi.html