1.语法:
CREATE TRIGGER <触发器名称> <--
{ BEFORE | AFTER }
{ INSERT | UPDATE | DELETE }
ON <表名称>
FOR EACH ROW
<触发器SQL语句>
eg:
DROP TRIGGER IF EXISTS t_ai;
CREATE TRIGGER t_ai AFTER INSERT ON t
FOR EACH ROW create temporary table tmp_table SELECT max(id) as id from t
DROP TRIGGER IF EXISTS t_ai;
CREATE TRIGGER t_ai AFTER INSERT ON t
FOR EACH ROW
BEGIN
IF NOT EXISTS tmp_table then
CREATE TEMPORARY tmp_table ( id bigint not null);
END IF;
INSERT INTO tmp_table(id) SELECT max(id) FROM t;
END;
附件官方教程