insert into boleht_development.`htprojects`(id,pname,`general`,imgsrc,whatwedo,howwedo,bp) select cid,cproject_use1,cproject_use4,imgsrc,what_we_do,how_we_do,business_plan from test.bole_cproject;
字段要对应好，一次得
原文：http://www.cnblogs.com/messipapa/p/4555127.html