高分求教

[coooky]

现有table

create table department
(
dep_id varchar(2),primary key
dep_name varchar(20)
)
我加入数据
( 01,销售部
02,账务部
03,管理部
)
我现在想把销售部,管理部合并为销售管理部,即
( 01,销售管理部
02,账务部
)
如何实现?

[coooky]

如果我现在是有级联的呢?

[coooky]

大家帮忙啊

[pengdali]

就这个呀。

update department set dep_name = '销售管理部' where dep_id = '01'
delete department where dep_id = '03'

[coooky]

但我希望原来与3管理部,01销售部级联的现在都与01,销售管理部关联

[leus]

update department set dep_name = '销售管理部' where dep_id = '01'
delete department where dep_id = '03'

[qdubit]

再强调一次：
update department set dep_name='销售管理部' where dep_id='01'
delete department where dep_id='03'

[axiaowin]

to 众位星星：
删除了管理部，对表里面的记录有没有影响？以前管理部里面的那些记录呢？

[yujohny]

update department
set dep_id='01',dep_name='销售管理部'
where dep_id='01' or dep_id='03'

[txlicenhe]

update department set dep_name = '销售管理部' where dep_id = '01'
delete department where dep_id = '03'

[yujohny]

不过如果有从表引用dep_id字段，
要记住报所有的从表中的dep_id为03改为01（如果有级联更新，那就不用理了）

[pengdali]

update department set dep_name='销售管理部' where dep_id='01'
delete department where dep_id='03'

[sdhdy]

update department set dep_name = '销售管理部' where dep_id = '01'
delete department where dep_id = '03'

[start1127]

这么个问题怎么吸引这么多大虾过来啊？

[shuiniu]

update department set dep_name = '销售管理部' where dep_id = '01'
delete department where dep_id = '03'
------------------------------
楼主不会，就这个要求吧！