oracle的merge语句和mysql的 ON DUPLICATE KEY UPDATE 的互相转换!!!
-- oraclemerge into BASE_EXT_DICT t using (select LOWER(word) word from base_negative_word where isvalid = #{isvalid} ) s on (s.word = t.ext_word and t.ext_type =1 and t.isvalid = 1 ) when matched then UPDATE SET t.updatetime = S...
原创
2020-07-27 15:19:08 ·
1478 阅读 ·
0 评论