python爬虫学习43
数据存储篇——MySQL储存
6. 删除数据
执行删除语句要使用 delete :
现在数据表students中有以下三条数据:
import pymysql
database = pymysql.connect(host='localhost', user='root', password='123456', port=3306, db='spider1')
cursor = database.cursor()
table = 'students'
condition = 'age < 16'
# 删除表中 年龄小于 16 的记录
sql = f'delete from