Python实战笔记-插入数据库3

import pymysql

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

sql = “insert into article(id,title,content) values(null,‘222’,‘333’)”

cursor.execute(sql)

title = ‘555’
content = ‘666’
sql = “insert into article(id,title,content) values(null,%s,%s)”
cursor.execute(sql,(title,content))

db.commit()
db.close()