字段间隔 ‘,’
行间隔‘|’
字段值 enclosed ’”‘
MYSQL必须设定字符集为UTF-8
find / -iname '*.cnf' -print
编辑找到的my.cnf
gedit /etc/my.cnf
在[mysqld]下添加
default-character-set=utf8
在[client]下添加(若无【client】则添加)
default-character-set=utf8
重启MYSQL服务
将sql_server导出的文本文件用GEDIT另存为UTF-8
load data infile 'aaaa' into table teachers fields terminated by ',' enclosed by '"' lines terminated by '|' (code,XM,PY,XBM,SR,ZMDM,XP,XSDM,XW,ZCDM,DH,EMAIL,JXKC,CGXJ,ZYDM1,ZYDM2,ZYDM3,DSLBM,PSDNY,PBDNY,BYXX,DSSSS,YHSSS,DBSSS,YHBSS,ZYQK,fblw,image,mm,pyztm,dsnl,yjfx1,yjfx2,yjfx3,dzsj,bysj,xszc,kyjlc,zygzjl,back1,back2,back3,back5,mzm,mz,start,codeo,xsdm1,xsdm2,xsdm3,zjlx,zjhm,keshi,zgqk,cjgzsj,sxzy,bzlx,wglx,jg,ltsj,xuezhi,xwsj,pysj,sj,grzy,yjfx4,bz,grjj,xkrz,bszydm1,bszydm2,bszydm3,bsyjfx1,bsyjfx2,bsyjfx3,gzbh);