我使用这个代码进行数据导入表,发现数据并没有导入,只有表头,没有具体数据。
mysql数据导入
LOAD DATA LOCAL INFILE '/home/ec2-user/data.csv' INTO TABLE movie FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;
这是输入命令的结果
mysql> LOAD DATA LOCAL INFILE '/home/ec2-user/data.csv' INTO TABLE movie FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\r\n' IGN
ORE 1 LINES;
Query OK, 20991 rows affected, 6 warnings (0.44 sec)
Records: 20991 Deleted: 0 Skipped: 0 Warnings: 6
求问题原因和解决办法!