MySQL 触发器
用于审计记录操作
操作插入数据到users表 执行触发器(如下)
例子:
insert 触发器
DELIMITER $$
CREATE TRIGGER user_insert AFTER INSERT ON users #在users表执行 INSERT 之后触发
FOR EACH ROW #每行
BEGIN #开始 在users表中执行插入后 在`trigger_users`表中记录新插入的数据
INSERT INTO `trigger_users` (createDate , uname ,upwd ,u_insert) VALUES(NOW(),new.username,new.password,'innert');
END;
$$
DELIMITER $$
delete 触发器
DELIMITER $$
CREATE TRIGGER user_delete BEFORE DELETE ON users
FOR EACH ROW
BEGIN
INSERT INTO `trigger_users` (createDate , uname ,upwd ,u_insert) VALUES(NOW(),OLD.username,OLD.password,'delete');
END;
$$
DELIMITER ;