56,678
社区成员
发帖
与我相关
我的任务
分享
SET @MSG_CLIENT=CONCAT('INSERT INTO ALARM_MESSAGE_CLIENT (ALARM_ID,USER_ID,MESSAGE_MODE,ALARM_DESC,STATUS,ERROR_CODE,FLAG,INSERT_TIME,SEND_TIME) ',
' SELECT DISTINCT A.ID ALARM_ID,B.USER_ID,D.MESSAGE_MODE MESSAGE_MODE,CONCAT(''',
REPLACE(REPLACE(V_CONTENT,'{',''',A.'),'}',','''),
''') ALARM_DESC,NULL STATUS,NULL ERROR_CODE,0 FLAG,NOW() INSERT_TIME,NULL SEND_TIME FROM ',
' VIEW_ALARM_TYPE_CURRENT A, ALARM_USER_TIMES B ,ALARM_MESSAGE_CONFIG C,ALARM_MESSAGE_TEMPLATE D',
' WHERE A.ID=B.ALARM_ID AND A.ALARM_TYPE=C.ALARM_TYPE AND C.MESSAGE_TEMPLATE_ID=D.ID',
' AND C.MESSAGE_TEMPLATE_ID IS NOT NULL ',
' AND B.MESSAGE_TIMES<=C.MESSAGE_MAX_TIMES AND C.MESSAGE_TEMPLATE_ID=',V_ID);
PREPARE SQL_MSG_CLIENT FROM @MSG_CLIENT;
EXECUTE SQL_MSG_CLIENT;
DEALLOCATE PREPARE SQL_MSG_CLIENT;