表server_hospital 有一个字段ID,设为自动增加(用触发器做的)
我要从wh_d_hospital查出数据插入到这个表里,下面的语句,总是提示我没有足够的值,求:应如何书写insert into server_hospital select code as hospitalcode,name as hospitalname,'192.168.0.7' as serverip,'192.168.0.7' as servername,'tjwy' as databasename,'sa' as loginname,'' as password from wh_d_hospital
我要从wh_d_hospital查出数据插入到这个表里,下面的语句,总是提示我没有足够的值,求:应如何书写insert into server_hospital select code as hospitalcode,name as hospitalname,'192.168.0.7' as serverip,'192.168.0.7' as servername,'tjwy' as databasename,'sa' as loginname,'' as password from wh_d_hospital
select code as hospitalcode,name as hospitalname,'192.168.0.7' as serverip,'192.168.0.7' as servername,'tjwy' as databasename,'sa' as loginname,'' as password from wh_d_hospital
insert into server_hospital(除id以外的字段)
select code as hospitalcode,name as hospitalname,'192.168.0.7' as serverip,'192.168.0.7' as servername,'tjwy' as databasename,'sa' as loginname,'' as password from wh_d_hospital