mysql> select * from student;
+-----------+-------+------+------+-------+
| sno
| sname | ssex | sage | sdept |
+-----------+-------+------+------+-------+
| 200215121 | 李勇
| 男
|
20 | CS
|
| 200215122 | 刘晨
| 女
|
21 | CS
|
| 200215123 | 王敏
| 女
|
18 | MA
|
| 200215124 | 张立
| 男
|
19 | IS
|
+-----------+-------+------+------+-------+
mysql> select sno,sname,ssex,sage+1 as sage from student;
+-----------+-------+------+------+
| sno
| sname | ssex | sage |
+-----------+-------+------+------+
| 200215121 | 李勇
| 男
|
21 |
| 200215122 | 刘晨
| 女
|
22 |
| 200215123 | 王敏
| 女
|
19 |
| 200215124 | 张立
| 男
|
20 |
+-----------+-------+------+------+