本文提供了几个SQL语句的例子，包括查询用户信息、筛选特定条件的消息以及更新消息状态并提交更改。
select * from sm_user where user_code='brilliantg'--10018H10000000001Y8U
select * from sm_msg_content where subject='您的休假申请被graceh驳回' and ts>'2017-11-09 15:25:34' and isread='N' and isHandled='N'
update sm_msg_content
set isdelete='Y'
where subject='您的休假申请被graceh驳回' and ts>'2017-11-09 15:25:34' and isread='N' and isHandled='N';
commit;
select * from sm_msg_content where subject='您的休假申请被graceh驳回' and ts>'2017-11-09 15:25:34' and isread='N' and isHandled='N'
update sm_msg_content
set isdelete='Y'
where subject='您的休假申请被graceh驳回' and ts>'2017-11-09 15:25:34' and isread='N' and isHandled='N';
commit;
扫一扫
2175
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
