数据库作业7

创建触发器
1. 创建BEFORE INSERT触发器

DELIMITER //
CREATE TRIGGER product_bf_insert
BEFORE INSERT ON product
FOR EACH ROW
BEGIN
  INSERT INTO operate(Op_type, Op_time) VALUES ('INSERT', NOW());
END;
//
DELIMITER ;

2. 创建AFTER UPDATE触发器

DELIMITER //
CREATE TRIGGER product_af_update
AFTER UPDATE ON product
FOR EACH ROW
BEGIN
  INSERT INTO operate(Op_type, Op_time) VALUES ('UPDATE', NOW());
END;
//
DELIMITER ;

3. 创建AFTER DELETE触发器

DELIMITER //
CREATE TRIGGER product_af_del
AFTER DELETE ON product
FOR EACH ROW
BEGIN
  INSERT INTO operate(Op_type, Op_time) VALUES ('DELETE', NOW());
END;
//
DELIMITER ;

对product表执行操作
INSERT操作

INSERT INTO product(Id, Name, Function, Company, Address) 
VALUES (1, '产品1', '功能1', '厂家1', '地址1');

UPDATE操作

UPDATE product SET Name = '更新后的产品1' WHERE Id = 1;
DELETE操作
DELETE FROM product WHERE Id = 1;

删除触发器
1. 删除BEFORE INSERT触发器

DROP TRIGGER IF EXISTS product_bf_insert;

2. 删除AFTER UPDATE触发器
 

DROP TRIGGER IF EXISTS product_af_update;