56,677
社区成员
发帖
与我相关
我的任务
分享
mysql> create table t_rigofree (a int,b int, c int , d int);
Query OK, 0 rows affected (0.08 sec)
mysql>
mysql> delimiter |
mysql>
mysql> CREATE TRIGGER testref BEFORE INSERT ON t_rigofree
-> FOR EACH ROW BEGIN
-> if new.a is null then
-> set new.a=new.c;
-> end if;
-> if new.b is null then
-> set new.b=new.d;
-> end if;
-> END;
-> |
Query OK, 0 rows affected (0.11 sec)
mysql>
mysql> delimiter ;
mysql> insert into t_rigofree(a,b,c,d) values (1,2,3,4);
Query OK, 1 row affected (0.53 sec)
mysql> select * from t_rigofree;
+------+------+------+------+
| a | b | c | d |
+------+------+------+------+
| 1 | 2 | 3 | 4 |
+------+------+------+------+
1 row in set (0.00 sec)
mysql> insert into t_rigofree(c,d) values (33,44);
Query OK, 1 row affected (0.03 sec)
mysql> select * from t_rigofree;
+------+------+------+------+
| a | b | c | d |
+------+------+------+------+
| 1 | 2 | 3 | 4 |
| 33 | 44 | 33 | 44 |
+------+------+------+------+
2 rows in set (0.00 sec)
mysql>
mysql> select version();
+----------------------+
| version() |
+----------------------+
| 5.1.33-community-log |
+----------------------+
1 row in set (0.06 sec)
mysql>