sql基础--怎样查询单列数据

select 指定列名 from 从表中

mysql> select name from products;
+--------------------+
| name               |
+--------------------+
| Bird bean bag toy  |
| qunkanlu           |
| qunkanlu 50 number |
| hongqi             |
+--------------------+
4 rows in set (0.00 sec)