%,MOD

运算符说明

%,MOD 运算符用于取余运算。返回结果为 N 除以 M 的余数。

语法结构

> SELECT N % M, N MOD M;

示例

mysql> select 12 mod 5;
+--------+
| 12 % 5 |
+--------+
|      2 |
+--------+
1 row in set (0.00 sec)

create table t2(c1 int, c2 int);
insert into t2 values (-3, 2);
insert into t2 values (1, 2);

mysql> select c1 mod 2 from t2;
+--------+
| c1 % 2 |
+--------+
|     -1 |
|      1 |
+--------+
2 rows in set (0.01 sec)

mysql> select c1 mod c2 from t2;
+---------+
| c1 % c2 |
+---------+
|      -1 |
|       1 |
+---------+
2 rows in set (0.01 sec)