查询一个数据表中的数据并插入到另一个数据表

insert into xinlou_a_left select lname,lurl,lid from xinche_a_left where id in (12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47)

posted on 2012-03-27 18:32  fancing  阅读(260)  评论(0编辑  收藏  举报