How do I change all greater than .00 cents to .49 cents be .00 and all greater than .50 to be round off?
I'm using SqlYog btw.
Example:
price 1: 16:03
price 2: 16:53
Output:
price 1: 16:00
price 2: 17:00
How do I change all greater than .00 cents to .49 cents be .00 and all greater than .50 to be round off?
I'm using SqlYog btw.
Example:
price 1: 16:03
price 2: 16:53
Output:
price 1: 16:00
price 2: 17:00
try
select Round(column)
from: http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_round
I tried using round its not changing '0 affected rows'
update product set price1 = round(price1,2);
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.