MySQL第七次作业

要求

在product表上分别创建BEFORE INSERT、AFTER UPDATE和AFTER DELETE 3个触发器，
触发器名称分别为product_bf_insert、product_af_update和product_af_del。执行语句部分是向operate表插入操作方法和操作时间。

1.1 BEFORE INSERT 触发器

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

1.2 AFTER UPDATE 触发器

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

1.3 AFTER DELETE 触发器

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

对 product 表执行 INSERT、UPDATE 和 DELETE 操作
2.1 INSERT 操作

INSERT INTO product(Id, Name, Function, Company, Address)
VALUES (1, 'Product A', 'Function A', 'Company A', 'Address A');

2.2 UPDATE 操作

UPDATE product
SET Name = 'Updated Product A'
WHERE Id = 1;

2.3 DELETE 操作

DELETE FROM product
WHERE Id = 1;

3.删除 product_bf_insert 和 product_af_update 这两个触发器

DROP TRIGGER product_bf_insert;
DROP TRIGGER product_af_update;

原文地址：https://blog.csdn.net/taolichao30/article/details/140479503

免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！