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()