python插入数据到mysql

import pymysql

db = pymysql.connect(host="127.0.0.1",port=3306,user="root",password="root",database="csdn_crawler")
cursor = db.cursor()
# sql = "insert into article(id,title,content) values(null,'222','333')"
# cursor.execute(sql)

title = '444'
content = '555'
sql = "insert into article(id,title,content) values(null,%s,%s)"
cursor.execute(sql,(title,content))

db.commit()
db.close()