帮小弟写一条SQL语句！

dezhengwei 发布于 2009-10-27 15:25， 630 次点击

insert into ServerState(HostId,StateRoad,state)
values ((selcet HostId from hostlist where hostMac='00-1E-C9-53-B7-B0'),'n_i',OK)
我插入ServerState表格，现在第一个字段需要从hostlist表中获取。
ServerState表:
HostId  StateRoad   state
   1       n_i        ok

hostlist表：
HostId      hostMac
  1        00-1E-C9-53-B7-B0

2个表如上所示，该怎么插入呢

3 回复

gdy03492009-10-27 21:44

两个建议1、用游标
2、拆分成两个动作，1个insert1个update

happynight2009-10-28 09:30

insert into ServerState(HostId,StateRoad,state)
selcet HostId,'n_i',OK
from hostlist where hostMac='00-1E-C9-53-B7-B0'

gdy03492009-10-28 16:51

楼上所说的是介于n_i,OK都是常量可以这么做