mysql> SELECT CEILING(1.23); -> 2 mysql> SELECT CEILING(-1.23); -> -1 

For exact-value numeric arguments, the return value has an exact-value numeric type. For string or floating-point arguments, the return value has a floating-point type. 

• CONV( N , from_base , to_base ) 

Converts numbers between different number bases. Returns a string representation of the number N , converted from base from_base  to base to_base . Returns NULL  if any argument is NULL . The argument N  is interpreted as an integer, but may be specified as an integer or a string. The minimum base is 2  and the maximum base is 36 . If from_base  is a negative number, N  is regarded as a signed number. Otherwise, N  is treated as unsigned. CONV()  works with 64-bit precision. 

mysql> SELECT CONV(’a’,16,2); -> ’1010’ mysql> SELECT CONV(’6E’,18,8); -> ’172’ mysql> SELECT CONV(-17,10,-18); -> ’-H’ mysql> SELECT CONV(10+’10’+’10’+X’0a’,10,10); -> ’40’ 

• COS( X ) 

Returns the cosine of X , where X  is given in radians. 

mysql> SELECT COS(PI()); -> -1 

• COT( X ) 

Returns the cotangent of X . 

mysql> SELECT COT(12); -> -1.5726734063977 mysql> SELECT COT(0); -> out-of-range error 

• CRC32( expr ) 

Computes a cyclic redundancy check value and returns a 32-bit unsigned value. The result is NULL  if the argument is NULL . The argument is expected to be a string and (if possible) is treated as one if it is not. 

mysql> SELECT CRC32(’MySQL’); -> 3259397556 mysql> SELECT CRC32(’mysql’); -> 2501908538 

• DEGREES( X ) 

Returns the argument X , converted from radians to degrees. 

mysql> SELECT DEGREES(PI()); -> 180 mysql> SELECT DEGREES(PI() / 2); -> 90 

