insert into table1 (column0,column1,b.column2,b.column3) select 'name', column1,column2,column3 from table1 where column0 = 'dd'
插入的字段的数据类型和被插入的字段的数据类型应该一样,并且数目也应相等 不知道你的 “且设置column0为name”什么意思 insert into table1 value(column1,column2,column3) select column1,column2,column3 into b from table1 where column0 = 'dd'
楼主顺序错了 insert into tablename(col1,col2,col3 ..) values (z1,z2,z3 ....) --or insert into tablename(col1,col2,col3 ..) select col11,col12,col13.... form othertable where .....---soinsert into table1 (column0,b.column1,b.column2,b.column3) select 'name', column1,column2,column3 into b from table1 where column0 = 'dd'
啊,原来如此 insert into table1 value(column0,column1,column2,column3) select 'name',column1,column2,column3 into b from table1 where column0 = 'dd'
注意字段的数据类型一致 insert into table1 (column0,column1,b.column2,b.column3) select 'name', column1,column2,column3 from table1 where column0 = 'dd'
插入的字段的数据类型和被插入的字段的数据类型应该一样,并且数目也应相等
不知道你的 “且设置column0为name”什么意思
insert into table1 value(column1,column2,column3)
select column1,column2,column3 into b from table1 where column0 = 'dd'
insert into tablename(col1,col2,col3 ..) values (z1,z2,z3 ....)
--or
insert into tablename(col1,col2,col3 ..) select col11,col12,col13.... form othertable where .....---soinsert into table1 (column0,b.column1,b.column2,b.column3) select 'name', column1,column2,column3 into b from table1 where column0 = 'dd'
insert into table1 value(column0,column1,column2,column3)
select 'name',column1,column2,column3 into b from table1 where column0 = 'dd'
insert into table1 (column0,column1,b.column2,b.column3) select 'name', column1,column2,column3 from table1 where column0 = 'dd'