Thread
:
mysql load data 乱码的问题
View Single Post
#
2
IP: 112.84.200.44
2016-09-18, 12:31 PM
Pacific Junction
初级会员
Join Date: 2010-10-08
Posts: 2
如导入的文件是gbk,则改为:
load data local infile 'c:\\data.txt'
into table person2 character set gbk (name,age,city,salary); 这个是导入到表person2,语句的默认分隔符是tab
Pacific Junction
View Public Profile
Find all posts by Pacific Junction