DIVISION operator

MySQL division operator is used for integer division.

This function is useful in -

  • Division is used to scale quantities and establish proportions.
  • In statistics, division is a fundamental operation for calculating averages and means.
  • Division is extensively used in financial calculations, including interest rates, profit margins, investment returns, and various other financial metrics.
  • In graphic design and digital imaging, division is employed to adjust the scale of images, change resolutions, and control visual elements.
  • In SQL queries, division can be used to perform complex calculations on data stored in a database.
  • Division is pervasive in physics and engineering for solving equations, determining physical properties, and performing simulations.


num / num


Name Description
num Dividend.
/ Division operator.
num Divisor.

MySQL Version: 8.0

Example of MySQL DIVISION() function


SELECT 12 / 3;


The above MySQL statement divides 12 by 3.


mysql> SELECT 12 / 3;
| 12 / 3 |
| 4.0000 | 
1 row in set (0.00 sec)

All Mathematical Functions

Previous: DIV
Next: EXP()

Follow us on Facebook and Twitter for latest update.

We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook