excel导入mysql

=CONCATENATE("insert into physical_data  (gender,grade,height,weight,content,strength,xsyt,ytxs,ywqz,ty,zwtqq,sbb,jjb,fb)   values   ('",C3,"','",E3,"','",F3,"','",G3,"','",H3,"','",I3,"','",J3,"','",K3,"','",L3,"','",M3,"','",N3,"','",O3,"','",P3,"','",Q3,"');")

不同版本excel对concatenate参数个数有限制

当然，上有政策下有对策，可以先把几列合并在做总合并

转载于:https://www.cnblogs.com/jefffyang/archive/2013/01/22/2871622.html