mysql> select score,score+5,score-5,score*5,score/5 from 4a;+-------+---------+---------+---------+---------+| score | score+5 | score-5 | score*5 | score/5 |+-------+---------+---------+---------+---------+| 93 | 98 | 88 | 465 | 18.6000 || 35 | 40 | 30 | 175 | 7.0000 || 46 | 51 | 41 | 230 | 9.2000 || 56 | 61 | 51 | 280 | 11.2000 || 79 | 84 | 74 | 395 | 15.8000 || 91 | 96 | 86 | 455 | 18.2000 || 53 | 58 | 48 | 265 | 10.6000 || 56 | 61 | 51 | 280 | 11.2000 || 58 | 63 | 53 | 290 | 11.6000 || 68 | 73 | 63 | 340 | 13.6000 || 71 | 76 | 66 | 355 | 14.2000 || 93 | 98 | 88 | 465 | 18.6000 || 67 | 72 | 62 | 335 | 13.4000 || 78 | 83 | 73 | 390 | 15.6000 || 88 | 93 | 83 | 440 | 17.6000 || 90 | 95 | 85 | 450 | 18.0000 || 92 | 97 | 87 | 460 | 18.4000 || 47 | 52 | 42 | 235 | 9.4000 || 68 | 73 | 63 | 340 | 13.6000 || 78 | 83 | 73 | 390 | 15.6000 || 81 | 86 | 76 | 405 | 16.2000 || 88 | 93 | 83 | 440 | 17.6000 |+-------+---------+---------+---------+---------+22 rows in set (0.00 sec)
2.mysql求余操作：
mysql> select score,score%5 from 4a;+-------+---------+| score | score%5 |+-------+---------+| 93 | 3 || 35 | 0 || 46 | 1 || 56 | 1 || 79 | 4 || 91 | 1 || 53 | 3 || 56 | 1 || 58 | 3 || 68 | 3 || 71 | 1 || 93 | 3 || 67 | 2 || 78 | 3 || 88 | 3 || 90 | 0 || 92 | 2 || 47 | 2 || 68 | 3 || 78 | 3 || 81 | 1 || 88 | 3 |+-------+---------+22 rows in set (0.00 sec)
3.mysql求平均值操作：
蓝心千询
蓝心千询是vivo推出的一个多功能AI智能助手
34 查看详情
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)
以上就是mysql中加减乘除与求余和求平均值以及查询不等于某数值的实例的详细内容，更多请关注创想鸟其它相关文章！
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/391392.html
微信扫一扫 
支付宝扫一扫 
