update help?
Posted: Sat Feb 20, 2010 1:04 am
I have table in mysql name "act" contains 4 fields
id, name, marks, avg(float)
I give the query to sql as
UPDATE act SET avg = marks/550 *100
I want that the result (avg) in field should be 2 decimal point not more.
like 72.63 not 72.6333
How it is possible.
Please Help.
id, name, marks, avg(float)
I give the query to sql as
UPDATE act SET avg = marks/550 *100
I want that the result (avg) in field should be 2 decimal point not more.
like 72.63 not 72.6333
How it is possible.
Please Help.