pymysql连接mysql数据库
# 1.导入pymysql模块
import pymysql
# 2.调用connect()函数生成connection连接对象
conn = pymysql.connect(host='localhost',
user='root',
password='123456',
database='mydb',
charset='utf8')
# 3.调用cursor()方法，创建cursor对象
cursor = conn.cursor()
# 4.执行sql语句
data = [
(1,"张三","男","175","1993-12-12"),
(2,"李四","男","180","1993-11-11")
]
sql = "insert into employee(num, sex,name, height, birth) values(%s, %s, %s, %s, %s)" #pymysql的占位符为%s
try:
cursor.executemany(sql,data)
conn.commit()
except:
conn.rollback()
# 5.关闭cursor
cursor.close()
