使用pymysql插入数据到数据库表中的示例

import pymysql

conn = pymysql.connect(host='10.80.0.1', user='user_name', password='password!', database='database_name')
cursor = conn.cursor()

list_a = [
    ('aa', 'bb', 18),
    ('cc', 'dd', 19)
]  # 注意这里我们不再使用字典，而是使用元组

sql = "insert into table_user(first_name, last_name, age) values(%s, %s, %s)"
try:
    cursor.executemany(sql, list_a)
    conn.commit()
except Exception as e:
    conn.rollback()
    print(e)
finally:
    cursor.close()
    conn.close()