Thread: mysql load data 乱码的问题
View Single Post
  #2   IP: 112.84.200.44
Old 2016-09-18, 12:31 PM
Pacific Junction Pacific Junction is offline
初级会员
  
Join Date: 2010-10-08
Posts: 2
Pacific Junction 现在声名狼藉
Default
如导入的文件是gbk,则改为：



load data local infile 'c:\\data.txt'
into table person2 character set gbk (name,age,city,salary); 这个是导入到表person2，语句的默认分隔符是tab
Reply With Quote