Mysql, python, SQL not executing

Question

Hi I have this basic mysql code:

sql = 'INSERT INTO popularity (PersonNumber, Category, Value) VALUES (1,"Tennis","great")'
connection = MySQLdb.connect(host = "localhost", user = "***",
passwd = "***", db = "inb104") 
cursor = connection.cursor()
cursor.execute(sql)
cursor.close()
connection.close()

However, this doesn't insert anything to the database. why? The sql syntax is correct, because I have coppied the outputted sql variable into the mysql console directly. I know this code is working, because If I do: sql =' SELECT * FROM popularity' I can output the result in python.

Answer 1

connection.commit()

that will do the trick =D

Answer 2

You need to commit the transaction.

Answer 3

Because you forgot to commit the transaction before closing the cursor.