立即学习:https://edu.csdn.net/course/play/24756/280727?utm_source=blogtoedu
import pymysql
db=pymysql.connect(host="127.0.0.1",port=3306,user="root",password="123456",database="csdn-study")
cursor=db.cursor()
sql="insert into article(id,title,content)values(null,'222",'333')" (自动增长的赋值为null)
cursor.execute(sql)
db.commit() #提交
db.close()
或者:动态填取-用%s填坑
title='444'
content='333'
sql="insert into article(id,title,content)values(null,%s,%s)"
cursor.execute(sql,(title,content))
db.commit() #提交
db.close()