adilmarwat Posted February 20, 2010 Share Posted February 20, 2010 I have table in mysql name "act" contains 4 fields id, name, marks, avg(float)I give the query to sql asUPDATE act SET avg = marks/550 *100I want that the result (avg) in field should be 2 decimal point not more. like 72.63 not 72.6333How it is possible. Please Help. Link to comment Share on other sites More sharing options...
Synook Posted February 20, 2010 Share Posted February 20, 2010 http://dev.mysql.com/doc/refman/5.0/en/mat...#function_round Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.