mybatis中存在则更新,不存在则添加的SQL写法
标题mybatis中存在则更新,不存在则添加的SQL写法
merge into sys_user_online a
using (select count(1) co
from sys_user_online
where sessionid = #{sessionId}) b
on (b.co <![CDATA[ <> ]]> 0)
when matched then
update
set login_nam
原创
2020-11-05 18:09:00 ·
1068 阅读 ·
0 评论