python中pymysql的executemany使用方式

sql="insert into tablename (id,name) values (%s,%s)"

values=[(1,"zhangsan"),(2,"lisi")]
#或者
values=((1,"zhangsan"),(2,"lisi"))

cursor.executemany(sql,values)

list = []
for x in xinghao_items:
 
  values = (str(x).replace('nan',''))
  list.append(values)
  num = num + 1
  if num == 500000:
    sql = "insert into t_mlcc(part_number)values('%s')"
    cursor.executemany(sql.replace('\'',''),list)
    db.commit()
    # 执行sql语句
    print("============" + time.strftime('%Y-%m-%d %H:%M:%S') + "=====insert ok=====")
    num = 0 # 计数归零
    list.clear() # 清空list