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()


上一篇:
下一篇:
切换中文