O'Reilly logo

MySQL in a Nutshell by Russell J.T. Dyer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Table B-1. Arithmetic operators

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required