12.6.2 Mathematical Functions - MySQL

All mathematical functions return NULL in the event of an error. ABS( X ) ..... If you need one kind of rounding, you should use a well-defined function such as ...

dev.mysql.com