Python Mysqldb Wont Insert Into Db

Hi I have an issue with inserting info to my db. It doesn't give off an error.The code is here. import MySQLdb as m def Room(room): db = m.connect('localhost','root','password

Solution 1:

You didn't call commit() for the transaction in which you executed the INSERT.

In Python, the default action is to roll back work, unless you explicitly commit.

See also:

• Python MySQL - SELECTs work but not DELETEs?
• Python MySQLdb update query fails
• http://mysql-python.sourceforge.net/FAQ.html#my-data-disappeared-or-won-t-go-away