mybatis中insert into ...select ...from dual union all select ... from dual 提示sql命令未结束的问题

xiaoxiao2021-02-28  106

需要在插入时加上useGeneratedKeys="false"

原Mapper:

<insert id="insertProductRoleUser" parameterType="list"> INSERT INTO AMC_PRODUCT_ROLE_USER (user_id, role_id) <foreach collection="list" item="productRole" index="index" separator="union all"> SELECT #{productRole.user_id,jdbcType=VARCHAR}, #{productRole.role_id,jdbcType=VARCHAR} FROM DUAL </foreach> </insert> 新Mapper:

<insert id="insertProductRoleUser" parameterType="list" useGeneratedKeys="false"> INSERT INTO AMC_PRODUCT_ROLE_USER (user_id, role_id) <foreach collection="list" item="productRole" index="index" separator="union all"> SELECT #{productRole.user_id,jdbcType=VARCHAR}, #{productRole.role_id,jdbcType=VARCHAR} FROM DUAL </foreach> </insert>

转载请注明原文地址: https://www.6miu.com/read-59337.html

最新回复(0)