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;