MySQL导入CSV文件数据

用root登录

use test;

LOAD DATA INFILE "/var/lib/mysql-files/pv.csv"
INTO TABLE test_table
CHARACTER SET UTF8
COLUMNS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '"'
LINES TERMINATED BY '\n';