mysql中加减乘除与求余和求平均值以及查询不等于某数值的实例(2)-木庄网络博客

2022-02-04 10:49:02 PHP中文网数据库百度已收录

mysql> select score,avg(score) from 4a;
+-------+------------+
| score | avg(score) |
+-------+------------+
|    93 |    71.6364 |
+-------+------------+
1 row in set (0.00 sec)

4.mysql求不等于某数值操作：

mysql> select score,score!=88 from 4a;     
+-------+-----------+
| score | score!=88 |
+-------+-----------+
|    93 |         1 |
|    35 |         1 |
|    46 |         1 |
|    56 |         1 |
|    79 |         1 |
|    91 |         1 |
|    53 |         1 |
|    56 |         1 |
|    58 |         1 |
|    68 |         1 |
|    71 |         1 |
|    93 |         1 |
|    67 |         1 |
|    78 |         1 |
|    88 |         0 |
|    90 |         1 |
|    92 |         1 |
|    47 |         1 |
|    68 |         1 |
|    78 |         1 |
|    81 |         1 |
|    88 |         0 |
+-------+-----------+
22 rows in set (0.00 sec)