MySQL使用SELECT

您可以使用SELECT命令从表中获取数据。

获取所有行和列:

SELECT * FROM people;

age |  name  
-----+--------
  37 | Flavio
   8 | Roger

只获取name列:

SELECT name FROM people;

  name  
--------
 Flavio
 Roger

计算返回的结果数量：

SELECT COUNT(*) from people;

 count 
-------
     2

您可以通过添加WHERE子句来过滤表中的行:

SELECT age FROM people WHERE name='Flavio';

age 
-----
  37

查询结果可以按列值排序，升序(默认)或降序，使用ORDER by:

SELECT * FROM people ORDER BY name;

SELECT * FROM people ORDER BY name DESC;