shunjiang666
新手上路
UID 111421
精华
0
积分 11
帖子 5
金钱 11 喜悦币
威望 0
人脉 0
阅读权限 10
注册 2008-2-24
来自 北京
状态 离线
|
[广告]: 代充Paypal帐号美元
触发器问题
mysql> select * from a;//
+----+------+---------------+
| id | name | status |
+----+------+---------------+
| 1 | a | dsfsdf |
| 2 | b | sdfsdfsdfs |
| 3 | c | sdfsdfsd |
| 4 | d | sdggfgfg |
| 5 | e | dggg |
| 6 | f | fgfdgfd |
| 7 | g | ssffg |
| 8 | h | hfsdafsdfsdsd |
+----+------+---------------+
mysql> select * from b;//
+----+------+---------+
| id | code | status1 |
+----+------+---------+
| 1 | a | NULL |
+----+------+---------+
当向b表中插入数据时 判断b.code是否在a.name中
如果在 就修改b.status1=a.stutas where b.code=a.name
触发器能实现么 怎么实现
| 
phper |
|
