Python实战笔记-删除数据5

import pymysql

db = pymysql.connect(
host=“127.0.0.1”,
user=‘root’,
password=‘11111111’,
database=“pymysql_test”,
port=3306
)
cursor = db.cursor()

sql = “delete from article where id=2”
cursor.execute(sql)

db.commit()
db.close()