一、六类Mysql表触发器
1、INSERT后:
DELIMITER $$
DROP TRIGGER IF EXISTS tri_after_insert_tablename $$
create trigger tri_after_insert_tablename after insert on 表名
for each row begin
#sql语句
END$$
DELIMITER ;
2、INSERT前:
DELIMITER $$
DROP TRIGGER IF EXISTS tri_before_insert_tablename $$
create trigger tri_before_insert_tablename before insert on 表名
for each row begin
#sql语句
END$$
DELIMITER ;
3、UPDATE后:
DELIMITER $$
DROP TRIGGER IF EXISTS tri_after_update_tablename $$
create trigger tri_after_update_tablename after update on 表名
for each row begin
#sql语句
END$$
DELIMITER ;
4、UPDATE前:
DELIMITER $$
DROP TRIGGER IF EXISTS tri_before_updata_tablename $$
create trigger tri_before_updata_tablename before update on 表名
for each row begin
#sql语句
END$$
DELIMITER ;
5、DELETE后:
DELIMITER $$
DROP TRIGGER IF EXISTS tri_after_delete_tablename $$
create trigger tri_after_delete_tablename after