为什么在MYSQL中导入CSV时行中的数据被截断？

问：

我在Mysql中有一个表，如下所示：

CREATE TABLE `overig`.`test`(
`ID` INT(10) AUTO_INCREMENT,
`Order_ID` DECIMAL(10) NOT NULL,
`Price_total` DECIMAL(12,2),
PRIMARY KEY (`ID`)
);

我想导入以下 CSV：

Order_ID;Price_total
145131343;118,35
145131349;79,35

我将CSV数据加载到MYSQL表中：

LOAD DATA LOCAL INFILE 'test.csv' INTO TABLE `overig`.`test` 
FIELDS TERMINATED BY ';' 
ENCLOSED BY '"' 
LINES TERMINATED BY '\n' 
IGNORE 1 LINES
    (`Order_ID`, @Price_total)
    SET `Price_total` = 0 + REPLACE(@Price_total, ',', '.');

响应：

Query OK, 2 rows affected, 1 warning (0.04 sec)
Records: 2  Deleted: 0  Skipped: 0  Warnings: 1

mysql> show warnings;
+-------+------+--------------------------------------------------+
| Level | Code | Message                                          |
+-------+------+--------------------------------------------------+
| Note  | 1265 | Data truncated for column 'Price_total' at row 2 |
+-------+------+--------------------------------------------------+

为什么我会收到此警告？第 2 行和第 3 行的值有什么区别？

结果还可以，但我想了解警告。

mysql> select * from test;
+----+-----------+-------------+
| ID | Order_ID  | Price_total |
+----+-----------+-------------+
|  1 | 145131343 |      118.35 |
|  2 | 145131349 |       79.35 |
+----+-----------+-------------+
2 rows in set (0.00 sec)

如果我将 csv 中的顺序更改为：

Order_ID;Price_total
145131343;79,35
145131349;118,35

我得到以下内容：

Query OK, 2 rows affected, 1 warning (0.04 sec)
Records: 2  Deleted: 0  Skipped: 0  Warnings: 1

mysql> show warnings;
+-------+------+--------------------------------------------------+
| Level | Code | Message                                          |
+-------+------+--------------------------------------------------+
| Note  | 1265 | Data truncated for column 'Price_total' at row 1 |
+-------+------+--------------------------------------------------+
1 row in set (0.00 sec)

如果我像这样导入数据，则没有警告：

LOAD DATA LOCAL INFILE 'test4.csv' INTO TABLE `overig`.`test` FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES (
`Order_ID`, @Price_total)
SET 
`Price_total`  = REPLACE(@Price_total, ',','.');