How Can I Safely Insert Data into a MySQL Database and Handle Potential Errors?

Inserting Data into a MySQL Database

Your code encounters an issue while attempting to insert data into the database table. The code doesn't handle exceptions or properly commit the transaction.

To resolve this, consider the following optimized code:

import MySQLdb

# Establish a server connection
conn = MySQLdb.connect(host="localhost", user="root", passwd="newpassword", db="engy1")
cursor = conn.cursor()

# Execute the data insertion
try:
    cursor.execute("INSERT INTO anooog1 VALUES (%s, %s)", (188, 90))
    conn.commit()
except:
    conn.rollback()

# Close the connection
conn.close()

This revised code incorporates exception handling with a try/except block. If any errors occur during the insertion, a rollback is performed, ensuring data integrity. It also explicitly commits the transaction to make the changes permanent.

The above is the detailed content of How Can I Safely Insert Data into a MySQL Database and Handle Potential Errors?. For more information, please follow other related articles on the PHP Chinese website!