table1
-----------------------
id userName
1 aa
2 bb
table2
--------------------
id userName
上面是两个表的结构
我想通过 insert into table1 select userName from table2
同时我想把 table2 的 id 都赋值为 1
怎么实现啊?
|
#2
cyyu_ryh2007-05-11 11:47
|
|
#3
bygg2007-05-11 11:57
|
|
|
#4
ruffianshen2007-05-11 12:01
|
|
|
#5
flyboatzgc2007-05-11 21:17
|