import pymysql
con = pymysql.connect(host = 'localhost',user = 'root',password = '123456',database = 'python_db',port = 3306)
# 创建游标
cur = con.cursor()
sql = 'delete from students where name = %s'
# 执行sql语句
try:
cur.executemany(sql,[('小明'),('好好')])
con.commit() #提交事务
print('删除成功')
except Exception as e:
print(e)
con.rollback()
print('删除失败')
finally:
con.close()