Arithmetic Operators
The arithmetic operators in MySQL work only on numbers, not on strings. However, MySQL will convert a string into a number when in a numeric context if it can. If it can’t convert a particular string, it will return 0. Table B-1 lists the arithmetic operators allowed.
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 rather truncates them.
Operator | Use |
| Addition |
| Subtraction and negation |
| Multiplication |
| Division |
| Division of integers |
| Modulo division |
Get MySQL in a Nutshell, 2nd Edition 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.