本地文件数据样式
fields terminated by ‘\t’ 值字段之间的分隔符
load data local infile 'C:\\opt\\small.txt' into table test character set utf8 fields terminated by '\t';
本地文件数据样式
fields terminated by ‘\t’ 值字段之间的分隔符
load data local infile 'C:\\opt\\small.txt' into table test character set utf8 fields terminated by '\t';