mysql 批量插入 用两个foreach循环，为啥有问题了？代码如下

Question

INSERT INTO set_rule_pipeline_mapping(
corp_id ,
project_id ,
set_rule_id ,
pipeline_code ,
pipeline_obj_id ,
status_no ,
create_by ,
create_time ) values
separator=",">
(
#{corpId} ,
#{projectId} ,
#{setRuleId} ,
#{item}


separator=",">
,#{item},
#{statusNo},
#{createBy},
#{createTime} )

执行的sql:

INSERT INTO set_rule_pipeline_mapping(          corp_id ,          project_id ,          set_rule_id ,          pipeline_code ,          pipeline_obj_id ,          status_no ,          create_by ,          create_time ) values               (    ? ,          ? ,          ? ,          ?    ,     (    ? ,          ? ,          ? ,          ?    ,     (    ? ,          ? ,          ? ,          ?    ,     (    ? ,          ? ,          ? ,          ?    ,     (    ? ,          ? ,          ? ,          ?              ,?,           ?,          ?,          ? )    ,     ,?,           ?,          ?,          ? )    ,     ,?,           ?,          ?,          ? )    ,     ,?,           ?,          ?,          ? )    ,     ,?,           ?,          ?,          ? )

哪里有问题吗？

Answer 1

INSERT INTO users(name, age) VALUES ('姚明', 25), ('比尔.盖茨', 50), ('火星人', 600); 自己看