mysql update SET problem?
Posted: Fri Feb 19, 2010 6:50 am
I have mysql table name 'marks' contains 4 fields
id, name, marks, avg
I give the sql query to mysql table like that
Update marks SET avg = marks/550*100
which gives result but there is no decimal value like 70.35 it shows only 70.
How it is possible.
id, name, marks, avg
I give the sql query to mysql table like that
Update marks SET avg = marks/550*100
which gives result but there is no decimal value like 70.35 it shows only 70.
How it is possible.