sign

description

Syntax

TINYINT sign(DOUBLE x) 返回x的符号.负数，零或正数分别对应-1，0或1.

example

  1. mysql> select sign(3);
  2. +-----------+
  3. | sign(3.0) |
  4. +-----------+
  5. |         1 |
  6. +-----------+
  7. mysql> select sign(0);
  8. +-----------+
  9. | sign(0.0) |
  10. +-----------+
  11. |         0 |
  12. mysql> select sign(-10.0);
  13. +-------------+
  14. | sign(-10.0) |
  15. +-------------+
  16. |          -1 |
  17. +-------------+
  18. 1 row in set (0.01 sec)

keywords

  1. SIGN