用pymysql向mysql中插入数据

from pymysql import *

arr1 = [
    ['a','aa','aaa'],
    ['b','bb','bbb'],
    ['c','cc','ccc']
]

# 创建connection连接 user一般为root
connection = connect(
  host='localhost',
  port=3306,
  database='your_database_name', 
  user='your_user',
  password='your_password',
  charset='utf8'
)
# 获取cursor对象
cursor1 = connection.cursor()
# 执行sql语句
query = """
    INSERT INTO your_table_name
     VALUES (%s, %s, %s);
    """
for values in arr1:
  cursor1.execute(query, values)

# 提交之前的操作，如果之前已经执行多次的execute，那么就都进行提交
connection.commit()

# 关闭cursor对象
cursor1.close()
# 关闭connection对象
connection.close()

 

cursor.executemany(query, args)：可以执行多条sql语句。