56,800
社区成员




mysql> DELIMITER $$
mysql> CREATE TRIGGER testref BEFORE INSERT ON test1
-> FOR EACH ROW BEGIN
-> INSERT INTO test2 SET a2 = NEW.a1;
-> DELETE FROM test3 WHERE a3 = NEW.a1;
-> UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
-> END$$
Query OK, 0 rows affected (0.05 sec)
mysql> DELIMITER ;
mysql>
[/quote]
不行啊,这个也运行不了[/quote]
mysql> DELIMITER $$
mysql> CREATE TRIGGER testref BEFORE INSERT ON test1
-> FOR EACH ROW BEGIN
-> INSERT INTO test2 SET a2 = NEW.a1;
-> DELETE FROM test3 WHERE a3 = NEW.a1;
-> UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
-> END$$
Query OK, 0 rows affected (0.05 sec)
mysql> DELIMITER ;
mysql>
[/quote]mysql> DELIMITER $$
mysql> CREATE TRIGGER testref BEFORE INSERT ON test1
-> FOR EACH ROW BEGIN
-> INSERT INTO test2 SET a2 = NEW.a1;
-> DELETE FROM test3 WHERE a3 = NEW.a1;
-> UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
-> END$$
Query OK, 0 rows affected (0.05 sec)
mysql> DELIMITER ;
mysql>