| 触发器问题 |
|
|
| 2008-04-17 | ||||
|
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 触发器能实现么 怎么实现 发表评论
|
||||
| 下一篇 > |
|---|