TXT文件批量导入mysql（中文乱码问题解决）

今天将一批TXT数据导入mysql方便查询，这里记录一下正确过程。

1.首先建表，匹配字段。
2.清除模式
set sql_mode="";
3.批量导入(以空格未界划分)
load data local infile "path" into table xxx character set utf8
fields terminated by" " lines terminated by"\\r\\n";

其中使用，可视化界面下加不加结果一样。

load data语法粘贴：

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
    [REPLACE | IGNORE]
    INTO TABLE tbl_name
    [FIELDS
        [TERMINATED BY 'string']
        [[OPTIONALLY] ENCLOSED BY 'char']
        [ESCAPED BY 'char' ]
    ]
    [LINES
        [STARTING BY 'string']
        [TERMINATED BY 'string']
    ]
    [IGNORE number LINES]
    [(col_name_or_user_var,...)]
    [SET col_name = expr,...)]