python之pymysql

import pymysql

#创建链接，相当于socket
conn = pymysql.connect(host='127.0.0.1',user='root',passwd='456456',db='lxl_db')

#相当于创建一个实例
cur = conn.cursor() #选定一个光标

data = [('A',6,'2020-12-29','F'),
        ('B',6,'2020-12-29','F'),
        ('C',6,'2020-12-29','F')
        ]

reCount = cur.executemany('insert into student (name,age,register_date,genger) values(%s,%s,%s,%s)',data)
conn.commit()