借助以下 MySQL 语句，我们可以使用 SELECT 来计算表达式 -

SELECT expression;

上述语句没有引用任何表。以下是一些示例 -

mysql> Select 10 DIV 5;+----------+| 10 DIV 5 |+----------+|        2 |+----------+1 row in set (0.06 sec)mysql> Select 10*5;+------+| 10*5 |+------+|   50 |+------+1 row in set (0.00 sec)mysql> Set @var1 = 100, @var2 = 200;Query OK, 0 rows affected (0.00 sec)mysql> Select @Var1+@Var2;+-------------+| @Var1+@Var2 |+-------------+|         300 |+-------------+1 row in set (0.00 sec)