2.12.2 Arithmetic Operators

The following table shows supported arithmetic operators. Before MySQL 8.0.32, arithmetic operators are not supported with variable-length encoded string columns. See Section 2.7.1, “Encoding String Columns”. MySQL 8.0.32 removed these restrictions.

Table 2.3 Arithmetic Operators

Name	Description
DIV	Integer division
/	Division operator
-	Minus operator
%, MOD	Modulo operator
+	Addition operator
*	Multiplication operator
-	Change the sign of the argument