我正在尝试使用mysql命令行的LOAD DATA INFILE功能来加载csv文件。它既没有给出任何错误信息,也没有加载任何数据。请问有人能帮帮我吗?我正在使用以下命令:
mysql> LOAD DATA INFILE '/Applications/XAMPP/xamppfiles/htdocs/dev/__php__/mysql/data.csv'
-> INTO TABLE csvdata
-> FIELDS TERMINATED BY ','
-> OPTIONALLY ENCLOSED BY '"'
-> LINES TERMINATED BY '\n'
-> IGNORE 1 LINES;
Query OK, 0 rows affected (0.00 sec)
Records: 0 Deleted: 0 Skipped: 0 Warnings: 0
以下是我的CSV文件。
"emp_id","first_name","last_name","username"
"EMP1","Tibass","Deloris","Tibass1"
问候