Problem with Data truncated for column 'warning' at row 1

Hi.

Why I have this error?
The field warning is INT, 10.

Can u help me?

[SQL] INSERT INTO _sharpTbl
(
 ID
, `warning`
 )
SELECT
0
, CASE WHEN `warning` = ''
THEN 0
ELSE `warning` END
FROM _temp_sharpTbl 

[Err] 1265 - Data truncated for column 'warning' at row 1

what is the data type of column _temp_sharpTbl.warning?

Thanks Sir.

I try with INT, 10 and decimal 10, 4 but I have the same error.
Problem with comma?

yes

please do a SHOW CREATE TABLE for your table

Thanks Sir.

I fixed with:


SELECT SUBSTRING_INDEX(`warning`, ',', 1)x;
+--------+
| x      |
+--------+
| 25.470 |
+--------+

SELECT REPLACE(
              SUBSTRING_INDEX(x, ',', 1)
              , '.',''
              )y;
+-------+
| y     |
+-------+
| 25470 |
+-------+
1 row in set (0.00 sec)