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

[Miguel61]

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 

[jurn]

what is the data type of column _temp_sharpTbl.warning?

[Miguel61]

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?

[r937]

Problem with comma?

yes

please do a SHOW CREATE TABLE for your table

[Miguel61]

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)