数据库小白求问触发器

Question

现在有两张表 t_push_message和t_push_message_log，需求：如果t_push_message表中有记录，
则触发器将t_push_message移动到t_push_message_log中，就是将t_push_message表的数据添加到t_push_message_log中，再将t_push_message表中的数据清空

Answer 1

例如：
CREATE TRIGGER PUSHLOG_TRIGGER AFTER INSERT ON t_push_message
FOR EACH ROW BEGIN
INSERT INTO t_push_message(column1,column2) VALUE(data1,data2);
INSERT INTO t_push_message_log (column1,column2)
SELECT T.column1,T.column2 FROM t_push_message T;
DELETE * FROM t_push_message;
END;
参考自：
MySQL触发器(TRIGGER)用法介绍 http://www.data.5helpyou.com/article381.html