import pymysql db = pymysql('localhost', 'root', '123456', 'heimdall')
import pymysql
db = pymysql('localhost', 'root', '123456', 'heimdall')
cursor = db.cursor()
删除数据 delete = "delete from employee where age=19"
delete = "delete from employee where age=19"
删除失败就回滚 try: cursor.execute(delete) db.commit() except: db.rollback()
try: cursor.execute(delete) db.commit() except: db.rollback()
db.close()