Cannot insert into MySQL database using MySQLdb python [duplicate]

Question

I have been trying to insert into a MySQL database from python using the MySQLdb interface. While I have been able to successfully execute select queries, my insert queries do nothing. They return no errors, but also do not add anything to the database.

I simplified my program down to just this.

db = MySQLdb.connect(host='127.0.0.1',user=...,passwd=...,db=...)
cursor = db.cursor()
cursor.execute("""INSERT INTO user_event_log (username, major_event_id, minor_event_id, value, date) VALUES ('Test', 1, 1, '0.1', '2017-07-29')""")

Not sure if I am making a really dumb mistake, but I can't figure out why nothing is inserted.

Rachit kapadia · Accepted Answer · 2017-07-29 18:18:02Z

2

You need to commit changes in database and close the database. Please follow below changes of code:

import MySQLdb

# Open database connection
db = MySQLdb.connect(host='127.0.0.1',user=...,passwd=...,db=...)

# prepare a cursor object using cursor() method
cursor = db.cursor()
sql = """INSERT INTO user_event_log (username, major_event_id, minor_event_id, value, date) VALUES ('Test', 1, 1, '0.1', '2017-07-29')"""
try:
   # Execute the SQL command
   cursor.execute(sql)
   # Commit your changes in the database
   db.commit()
except:
   # Rollback in case there is any error
   db.rollback()

# disconnect from server
db.close()

answered Jul 29, 2017 at 18:18

Rachit kapadia

6997 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cosinepenguin · Accepted Answer · 2017-07-29 17:30:15Z

0

You need to add a MySQLdb.commit() to your connection. (Source)

This is as simple as adding db.commit() to the end of your code.

Hope it helps!

answered Jul 29, 2017 at 17:30

cosinepenguin

1,5751 gold badge13 silver badges22 bronze badges

Collectives™ on Stack Overflow

Cannot insert into MySQL database using MySQLdb python [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related