这里提供一个mysql触发器的demo:
DELIMITER $ -- 触发器开始标志
CREATE TRIGGER t2
AFTER INSERT ON `test_list`
FOR EACH ROW
BEGIN
INSERT INTO test_list_history (`name`,age) VALUES ((SELECT `name` FROM test_list ORDER BY id DESC LIMIT 1), 27);
END$ -- $触发器结束标志
这里提供一个mysql触发器的demo:
DELIMITER $ -- 触发器开始标志
CREATE TRIGGER t2
AFTER INSERT ON `test_list`
FOR EACH ROW
BEGIN
INSERT INTO test_list_history (`name`,age) VALUES ((SELECT `name` FROM test_list ORDER BY id DESC LIMIT 1), 27);
END$ -- $触发器结束标志