INSERT INTO
EVENTMASK
VALUE (
SELECT
EVENTID AS EVENTID
,#{EMPLOYEEID,jdbcType=VARCHAR}AS EMPLOYEEID
,#{FLAG,jdbcType=VARCHAR} AS FLAG
, #{UUID,jdbcType=VARCHAR} AS EVENTMASKUUID
from EVENT
not in( select EVENTID
from
EVENTMASK
where
EMPLOYEEID = #{EMPLOYEEID,jdbcType=VARCHAR}
)
)
oracle,把A表在B表没有的字段数据插入到B中
最新推荐文章于 2023-06-09 19:08:29 发布