Python MySQL insert

Question

I have a problem with an insert in python. All the attributes are correct and it gives no errors. Here is my code:

db = MySQLdb.connect(host="localhost", user="root", passwd="", db="ueberwachung") #Datenbank connection
cur = db.cursor()
cur.execute("INSERT INTO tereignisse VALUES('1002', '2016-12-02','18:34:15','/var/www/html/videos/2016-11-0103:21:13', '0')") 
cur.close()
db.close()

Edit: Sorry I forgot the problem. So problem: It doesn't write anything into the table.

Errors? Output? Anything? Computer making beeping noises or catching on fire? — tadman, Dec 03 '16 at 18:47
It doesn't write anything because you don't `commit()` the transaction — roganjosh, Dec 03 '16 at 18:48
Check http://stackoverflow.com/questions/384228/database-does-not-update-automatically-with-mysql-and-python — Kenly, Dec 03 '16 at 18:53

score 2 · Accepted Answer · answered Dec 03 '16 at 18:52

2

You need to commit the transaction before closing the connection:

db.commit()
cur.close()
db.close()

answered Dec 03 '16 at 18:52

Soroush

1,055
2
18
26

Python MySQL insert

1 Answers1