页次: 1
mysql 中的算法运算符包括 +, -, *(乘法), /(除法), %(取余数)
示例
mysql> select 1+2 , 1-2, 3+3, 3/2, 5%3; +-----+-----+-----+--------+------+ | 1+2 | 1-2 | 3+3 | 3/2 | 5%3 | +-----+-----+-----+--------+------+ | 3 | -1 | 6 | 1.5000 | 2 | +-----+-----+-----+--------+------+ 1 row in set (0.04 sec)
取余 就是 获得余数
ipbbs.net
离线
页次: 1