表元素的删除

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