/

Description

The / operator is used for division.

Syntax

  1. > SELECT value1/value2;
  1. > SELECT column1/column2... FROM table_name;

Division by zero produces a error result.

Examples

  1. > select 1123.2333/1233.3331;
  2. +-----------------------+
  3. | 1123.2333 / 1233.3331 |
  4. +-----------------------+
  5. |    0.9107298750029493 |
  6. +-----------------------+
  7. 1 row in set (0.00 sec)
  1. > create table t2(c1 int, c2 int);
  2. > insert into t2 values (-3, 2);
  3. > insert into t2 values (1, 2);
  4. > select c1/2 from t2;
  5. +--------+
  6. | c1 / 2 |
  7. +--------+
  8. |   -1.5 |
  9. |    0.5 |
  10. +--------+
  11. 2 rows in set (0.00 sec)
  12. > select c1/c2 from t2;
  13. +---------+
  14. | c1 / c2 |
  15. +---------+
  16. |    -1.5 |
  17. |     0.5 |
  18. +---------+
  19. 2 rows in set (0.01 sec)