【无标题】

1. 创建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;