表间转移数据，新增字段(转)

insert into B select A.*  'value_c1','value_c2','value_c3'  from A where now_id = '$ID'是可以的.

但是如果B 表中新加了一個自動獲取的new_id,那么字段就無法匹配了,

是不是加了一個自動獲取的id就不能用了呢?[/size]

http://www.phpx.com/happy/archiver/tid-126990.html 

 

deltete from hbtest.dbo.blog_article
set IDENTITY_INSERT hbtest.dbo.blog_article On
insert into hbtest.dbo.blog_article (id,title,titleid,author,[content],userid) select id,title,titleid,author,[content],userid from ds_blog.dbo.blog_article
set IDENTITY_INSERT hbtest.dbo.blog_article OFF

select top 20 id,titleid,'ab' as a,1 as tid from blog_article