python
import MySQLdb
db = MySQLdb.connect("localhost", "username", "password", "dbname")
cursor = db.cursor()
sql = "UPDATE employees SET salary = 5000 WHERE id = 1"
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
db.close()
python
import MySQLdb
db = MySQLdb.connect("localhost", "username", "password", "dbname")
cursor = db.cursor()
sql = "DELETE FROM employees WHERE id = 1"
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
db.close()