import pymysql
# 删除数据
db = pymysql.connect("localhost", "root", "wsw..177122", "wakey")
cursor = db.cursor()
sql = 'delete from bandcard where money =200'
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
cursor.close()
db.close()