python MySQL 批量插入

# coding:utf-8import pymysql# 打开数据库连接db = pymysql.connect(host='localhost', port=3306,                     user='username', passwd='password', db='database_name', charset='utf8')# 使用cursor()方法获取操作游标cursor = db.cursor()# SQL 插入语句sql = "INSERT INTO EMPLOYEE(FIRST_NAME, AGE, SEX) VALUES (%s,%s,%s)"# 一个tuple或者listT = (('xiaoming', 31, 'boy'), ('hong', 22, 'girl'), ('wang', 90, 'man'))try:    # 执行sql语句    cursor.executemany(sql, T)    # 提交到数据库执行    db.commit()except :    # 如果发生错误则回滚    db.rollback()# 关闭游标cursor.close()# 关闭数据库连接db.close()

转自：https://www.ctolib.com/TracyMcgrady6-pymsql_Operation.html