批量插入 executemany

conn = pymysql.connect(host=DBParems.sql_host.value,
                                    # port=server.local_bind_port,
                                    user=DBParems.sql_user.value,
                                    passwd=DBParems.sql_password.value,
                                    db=DBParems.sql_db.value)
cur=conn.cursor()
sql = 'insert into hospital(name,age,sex) values(%s,%s,%s)'
col_data = (('pp',12,male),('qq',21,female),('oo',31,male))
cur.executemany(sql,col_data)
cur.commit()
conn.close()