- 创建BEFORE INSERT触发器(product_bf_insert):
REATE TRIGGER product_bf_insert
BEFORE INSERT ON product
FOR EACH ROW
BEGIN
INSERT INTO operate (operation, operation_time)
VALUES ('insert', NOW());
END;
2.创建AFTER UPDATE触发器(product_af_update):
CREATE TRIGGER product_bf_insert
BEFORE INSERT ON product
FOR EACH ROW
BEGIN
INSERT INTO operate (operation, operation_time)
VALUES ('insert', NOW());
END;
3.创建AFTER DELETE触发器(product_af_del)
CREATE TRIGGER product_af_del
AFTER DELETE ON product
FOR EACH ROW
BEGIN
INSERT INTO operate (operation, operation_time)
VALUES ('delete', NOW());
END;
4.执行INSERT、UPDATE和DELETE操作: 执行具体的SQL命令,例如插入数据:
INSERT INTO product ...;
UPDATE product SET column = value WHERE condition;
DELETE FROM product WHERE condition;
5.删除触发器:
DROP TRIGGER product_bf_insert;
DROP TRIGGER product_af_update;