MySQL执行LOAD DATA INFILE显示Query OK但无数据导入求助

我正在完成数据库课程作业，使用MySQL的LOAD DATA INFILE命令导入CSV数据时遇到问题，执行后显示0行受影响，无任何数据导入。

执行的导入命令 #

LOAD DATA INFILE '/example/file/path.csv'
INTO TABLE example_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
IGNORE 1 ROWS;

执行结果 #

Query OK, 0 rows affected (0.00 sec)
Records: 0 Deleted: 0 Skipped: 0 Warnings: 0

CSV数据示例 #

目标表结构（DESCRIBE结果） #

+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| vehicle_ID | int          | YES  |     | NULL    |       |
| state      | varchar(2)   | YES  |     | NULL    |       |
| repair     | varchar(50)  | YES  |     | NULL    |       |
| reason     | varchar(50)  | YES  |     | NULL    |       |
| year       | year         | YES  |     | NULL    |       |
| make       | varchar(25)  | YES  |     | NULL    |       |
| body_type  | varchar(100) | YES  |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+
7 rows in set (0.00 sec)

已完成的排查操作 #

• 确认所有VARCHAR字段长度未超出表定义
• 确认vehicle_ID字段值均为整数
• 确认year字段值均为4位整数，符合MySQL YEAR类型要求
• 确认CSV文件存在且包含有效数据
• 确认文件路径输入正确
• 重启MySQL会话后重新尝试导入
• 确认当前操作的数据库正确，目标表example_table存在

补充的CSV原始数据片段 #

Vehicle ID,State,Repair ,Reason,YEAR ,Make,Body Type 
15241383936,AL,Battery replacement,Dead battery,2016,RAM ,"1500 4WD Quad Cab 140.5"" SLT"
15241383936,AL,Dent Repair  Left Fender,Collision,2016,RAM ,"1500 4WD Quad Cab 140.5"" SLT"
60965535744,AL,Battery replacement,Dead battery,2016,RAM ,"1500 4WD Quad Cab 140.5"" SLT"
60965535744,AL,Tire repair,Flat- reparable,2016,RAM ,"1500 4WD Quad Cab 140.5"" SLT"
60965535744,AL,Tire replacement,Flat- hole not reparable,2016,RAM ,"1500 4WD Quad Cab 140.5"" SLT"
1.37172E+11,AL,Battery replacement,Dead battery,2017,Chevrolet Silverado ,"1500 4WD Double Cab 143.5"" LT w/1LT"

请求排查导入无数据的原因，提供技术帮助。

内容的提问来源于stack exchange，提问作者Cade Bray