MySQL之SELECT函数
1. 使用st数据库
Mysql>use st
2. 查询student表里的数据,显示所有字段的数据
mysql> select * from student;
+-----------+--------+------+------+-------+
| Sno | Sname | Ssex | Sage | Sdept |
+-----------+--------+------+------+-------+
| 201215121 | 李勇 | 男 | 20 | CS |
| 201215122 | 刘晨 | 女 | 19 | CS |
| 201215123 | 王小敏 | 女 | 18 | MA |
| 201215124 | 张立 | 男 | 19 | IS |
| 201215125 | 王敏 | 女 | 18 | A |
+-----------+--------+------+------+-------+
5 rows in set (0.00 sec)
3. 查询student表中的数据,只显示name字段的数据
mysql> select name from student;
ERROR 1054 (42S22): Unknown column 'name' in 'field list'
mysql> select Sname from student;
+--------+
| Sname |
+--------+
| 李勇 |
| 刘晨 |
| 王敏 |
| 王小敏 |
| 张立 |
+--------+
5 rows in set (0.00 sec)
4.按条件进行查询,查询年龄大于19的数据
mysql> select * from student where age >19;
ERROR 1054 (42S22): Unknown column 'age' in 'where clause'
mysql> select * from student where Sage >19;
+-----------+-------+------+------+-------+
| Sno | Sname | Ssex | Sage | Sdept |
+-----------+-------+------</