MYSQL : Arithmetic Operations

[VelMurugan]

Arithmetic Operations :

    In MySQL, we have the usual Arithmetic operations. Lets see the arithmetic operators one by one with an example.

Addition (+) :

mysql> select 5+5;
-->  10

Subtraction (-) :

mysql> select 25-18;
-->  7

Multiplication (*) :

mysql> select 4*4;
-->  16

Division (/) :

mysql> select 5/3;
-->  1.67