Arithmetic Operators : Introduction « Math Numeric Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. Introduction
NameDescription
/Division operator
DIVInteger division
-Minus operator
%Modulo operator
+Addition operator
*Times operator
-Change the sign of the argument










21.1.Introduction
21.1.1.Numeric Functions
21.1.2.Arithmetic Operators
21.1.3.Addition
21.1.4.To add the totals of both columns for every row
21.1.5.Subtraction
21.1.6.Total the two columns and then subtract them
21.1.7.Multiplication
21.1.8.SUM then Multiply
21.1.9.Division
21.1.10.A NULL value will be returned if you try to divide by zero