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;

字段要对应好,一次得

原文地址:https://www.cnblogs.com/messipapa/p/4555127.html