自写(已测试)
mysql> create trigger t2 before delete on
data for each row update chars set count=count-char_length(old.name);
Query OK, 0 rows affected (0.03 sec)
mysql> CREATE TABLE audit (id INT(7), balance FLOAT, user VARCHAR(50)
NOT NULL, time TIMESTAMP NOT NULL);
Query OK, 0 rows affected (0.09 sec)
mysql> create table accounts(id int(7),label VARCHAR(45),balance float);
接下来,我将在accounts表格中定义一个触发器。(列表D) 列表D
mysql> CREATE TRIGGER t3 AFTER UPDATE ON accounts
FOR EACH ROW INSERT INTO audit (id, balance, user, time)
VALUES (OLD.id, NEW.balance, CURRENT_USER(), NOW());
Query OK, 0 rows affected (0.04 sec)