MySQL error: # 1265 - Truncated data for column 'value' on line 1

Question

Navigation

#1 by (1 votes)

0

Good afternoon, guys. I gave the following command in MySQL:

UPDATE procedimentos SET valor = '2.400.00' WHERE procedimentos.id_proced = 1

The value field is a double , I already tried with float and gave the same error, what exactly would it be?

php sql

asked by anonymous 05.02.2018 / 15:55

1 answer

score 1 · Answer 1

Only one point should be used when necessary. It is also not necessary to use plications.

If the value to update is 2400, you can only stay:

UPDATE procedimentos SET valor = 2400 WHERE procedimentos.id_proced = 1

If it is 2.4:

UPDATE procedimentos SET valor = 2.4 WHERE procedimentos.id_proced = 1