mysql 挑选列导入

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;

字段要对应好,一次得

posted @ 2015-06-05 17:12  梅西爸爸  阅读(174)  评论(0编辑  收藏  举报