这个好办啊!转个弯不就行了
begin transaction
insert into odu(num,qt,wu,tes) select num,qt,wu,wu from mybo
update odu set tes = '1'
commit transaction
begin transaction
insert into odu(num,qt,wu,tes) select num,qt,wu,wu from mybo
update odu set tes = '1'
commit transaction
num varchar(10) not null,
tes varchar(10) not null,
qt varchar(10),
wu varchar(10)
)
gocreate table mybo(
num varchar(10),
qt varchar(10),
wu varchar(10),
)
goinsert into mybo values('1','11','aaa')
insert into mybo values('2','22','bbb')
insert into mybo values('3','33','ccc')
insert into mybo values('4','44','ddd')
insert into mybo values('5','55','eee')
goinsert into odu(num,tes,qt,wu) select num,1,qt,wu from myboselect * from odu
select * from mybo不知是不是这个意思?