APS_IRON_PRO_ASSEMBLY_CONFIG 批量插入 SQL 语句分析

这个 SQL 语句似乎没有明显的语法错误，但是无法判断其是否符合业务逻辑。需要根据具体的需求和数据表结构进行验证。<select id="batchInsert2" parameterType="java.util.List" resultType="integer"> insert into APS_IRON_PRO_ASSEMBLY_CONFIG (assemblyType,processAssemblyJson,ironType,yokeSideStructure,wiotCode,apsDeviceName,createUser,singlePillarProcessType,createTime,lastEditUser,lastTime,isDeleted,baseCalType,pillarCode,scriptId,efficiencyCalType) output inserted.id values <foreach collection="list" separator="," item="item"> (#{item.assemblyType}, #{item.processAssemblyJson}, #{item.ironType}, #{item.yokeSideStructure}, #{item.wiotCode},#{item.apsDeviceName},#{item.wiotCode},#{item.createUser},#{item.singlePillarProcessType},#{item.createTime},#{item.lastTime},#{item.isDeleted},#{item.wiotCode},#{item.baseCalType},#{item.scriptId},#{item.efficiencyCalType}) </foreach> </select>