Arithmetic Operators
The arithmetic operators in MySQL work only on numbers, and not on strings. However, MySQL will convert a string as a number when in a numeric context if it can. If it can’t convert a particular string, it will convert it to 0. The arithmetic operators allowed are listed in Table B-1.
Operator |
Use |
+ |
Addition |
- |
Subtraction and negation |
* |
Multiplication |
/ |
Division |
DIV |
Division of integers |
% |
Modulo division |
The minus sign may be used for subtracting numbers or for setting a
number to a negative. The DIV
operator converts
values to integers and returns only integers. It
doesn’t round fractions that would be returned, but
truncates them.
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.