1.MySQL-Additions-, Subtraktions-, Multiplikations- und Divisionsoperationen:
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-Restoperation:
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-Durchschnittsoperation:
mysql> select score,avg(score) from 4a; +-------+------------+ | score | avg(score) | +-------+------------+ | 93 | 71.6364 | +-------+------------+ 1 row in set (0.00 sec)
4.MySQL-Operation, um herauszufinden, ob sie einem bestimmten Wert nicht entspricht:
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)
Das obige ist der detaillierte Inhalt vonBeispiele für Addition, Subtraktion, Multiplikation, Division, Restsumme, Durchschnitt und Abfrage, die nicht einem bestimmten Wert in MySQL entsprechen. Für weitere Informationen folgen Sie bitte anderen verwandten Artikeln auf der PHP chinesischen Website!