pymysql删除

删除数据

import pymysql
db = pymysql('localhost', 'root', '123456', 'heimdall')

cursor = db.cursor()

  • 删除数据
    delete = "delete from employee where age=19"

  • 删除失败就回滚
    try: cursor.execute(delete) db.commit() except: db.rollback()

db.close()

posted @ 2020-06-25 13:18  bibicode  阅读(1315)  评论(0)    收藏  举报