Mysql error : #1265 - Truncated data for 'value' column in row 1

Asked

Viewed 4,475 times

0

Good afternoon, you 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’ve tried with float and made the same mistake, which would be exactly ?

php sql database

  • I believe the problem is formatting; I don’t know how your database is but I think I should use 2.400,00 or 2,400.00

  • I tried as I said, but kept returning the same mistake!

1 answer

1

Only one stitch should be used when necessary. There is also no need to use.

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

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

  • Now it all makes sense!(that meme) haha' Thank you so much for your help! .

  • @Williambarreto remember to mark the answer as correct ;)

Browser other questions tagged php sql database

You are not signed in. Login or sign up in order to post.