mysql 算术运算符_MySQL 算术运算符简介说明

摘要:

下文讲述MySQL算术运算符的简介说明，如下所示：

下文讲述MySQL数据库中5种算术运算符，如下:

+加法

–减法

*乘法

/ 或 DIV除法

% 或 MOD取余

下文将依次举例讲述MySQL5种算术运算符

mysql > select 88+901;

+--------+

| 88+901 |

+--------+

| 989 |

+--------+

1 row in set (0.00 sec)

mysql > select 90-8;

+------+

| 90-8 |

+------+

| 82 |

+------+

1 row in set (0.00 sec)

mysql > select 8-90;

+------+

| 8-90 |

+------+

| -82 |

+------+

1 row in set (0.00 sec)

mysql > select 8*1

-> ;

+-----+

| 8*1 |

+-----+

| 8 |

+-----+

1 row in set (0.00 sec)

mysql> select 8/2;

+--------+

| 8/2 |

+--------+

| 4.0000 |

+--------+

1 row in set (0.00 sec)

mysql> select 8%3;

+------+

| 8%3 |

+------+

| 2 |

+------+

1 row in set (0.00 sec)

mysql> select 8 mod 3;

+---------+

| 8 mod 3 |

+---------+

| 2 |

+---------+

1 row in set (0.00 sec)

mysql> select 8 div 2;

+---------+

| 8 div 2 |

+---------+

| 4 |

+---------+

1 row in set (0.00 sec)

mysql_算数运算举例说明