顺便贴个触发器给你 DELIMITER | 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 |CREATE TRIGGER 触发器名 before\after Inset\delete\update on 那个表 然后干你的事,具体使用还是看看手册啦,学习不能太懒
-> id int(2) not null primary key auto_increment,
-> str_a varchar(50),
-> str_b varchar(50) default "hello world");
Query OK, 0 rows affected (0.19 sec)mysql> insert into test set str_a = "world hello";
Query OK, 1 row affected (0.05 sec)mysql> select * from test;
+----+-------------+-------------+
| id | str_a | str_b |
+----+-------------+-------------+
| 1 | world hello | hello world |
+----+-------------+-------------+
1 row in set (0.00 sec)mysql>
str_b下面是没有默认值的,也就是在插如str_a的同时,我想插入任意的一个数值都可以
DELIMITER |
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
|CREATE TRIGGER 触发器名 before\after Inset\delete\update on 那个表
然后干你的事,具体使用还是看看手册啦,学习不能太懒