mysql>mysql> SELECT TRUNCATE(122,-2);+------------------+| TRUNCATE(122,-2) |+------------------+| 100 |+------------------+1 row in set (0.00 sec)mysql>