小问题,100分!(100分)

Z

zhugenan

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-06-05

• #1

请问:两个不同的表A和B,各有一个字段相同类型,但字段名称不同,但其中一个表数据被删,想把另一个表中相同字段数据倒过来,在INSERT中是否可用SELECT一句话倒过来,如:
insert into a (a1,a2,a3)
vaules ((select b1 from b),0,0)
注:提示错误为b1非法

 

X

xWolf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-06-05

• #2

insert into a(a1, a2, a3)
select b1, b2 = 0, b3 = 0 from b

 

C

Crab

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-06-05

• #3

应该是 insert into a(a1,a2,a3) select b1,0,0 from b

 

Z

zhugenan

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-06-05

• #4

thanks!