在centos下，将txt里的数据导入到mysql表中指定的列中

mysql> show variables like '%secure%';   # txt要放secure_file_priv的文件夹里才能导入；如果secure_file_priv 为 NULL ，则修改mysql安装目录下my.ini文件，在[mysqld]下添加secure_file_priv = /目录/ 保存并退出
mysql> load data infile '/var/lib/mysql-files/user.txt' ignore into table UserChat.user character set utf8mb4 lines terminated by '\n' (nickname,username,password,vip,gameid);  ## 导入user.txt 到user表
Query OK, 3 rows affected (0.01 sec)
Records: 3  Deleted: 0  Skipped: 0  Warnings: 0

load data infile ‘/var/lib/mysql-files/user.txt’ ignore into table UserChat.user character set utf8mb4 lines terminated by ‘\n’ (nickname,username,password,vip,gameid);这句中的 lines terminated by ‘\n’ 表示每条数据用换行符分开，如果是windows则是"\r\n"

Load Data InFile 'C:/Data.txt' Into Table `TableTest` Fields Terminated By ',' Enclosed By '"' Escaped By '"' Lines Terminated By '\r\n';  # 这句中的  Fields Terminated By ',' Enclosed By '"' Escaped By '"'  表示每个字段用逗号分开，内容包含在双引号内