标题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_name = #{loginName},
expire_time = #{expireTime}
where sessionid = #{sessionId}
when not matched then
insert (sessionId,login_name,expire_time)
values
(#{sessionId}, #{loginName}, #{expireTime});