mysql 触发器

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; 

 

 

附件官方教程