MySQL Forums
Forum List  »  Newbie

Update in decimal
Posted by: Daniel Carvalho Dan
Date: March 25, 2015 09:52AM

Hello if anyone can help thanks.
I have a Products table and a field called price.
There are already records in the table where prices are with broken values

example:
10.8888
11.2548
100.2348



I need everything that comes after the point(.) becomes zero. example

10.8888 to 10.0000
11.2548 to 11.0000
100.2348 to 100.0000

What would be the command to update that way on all products of my table?

Thank you in advance

Options: ReplyQuote


Subject
Written By
Posted
Update in decimal
March 25, 2015 09:52AM
March 25, 2015 11:01AM
March 25, 2015 03:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.