pmod

description

Syntax

1. BIGINT PMOD(BIGINT x, BIGINT y)
2. DOUBLE PMOD(DOUBLE x, DOUBLE y)

返回在模系下x mod y的最小正数解. 具体地来说, 返回 (x%y+y)%y.

example

1. MySQL [test]> SELECT PMOD(13,5);
2. +-------------+
3. | pmod(13, 5) |
4. +-------------+
5. |           3 |
6. +-------------+
7. MySQL [test]> SELECT PMOD(-13,5);
8. +-------------+
9. | pmod(-13, 5) |
10. +-------------+
11. |           2 |
12. +-------------+

keywords

1. PMOD