mysql查询语句的基本用法

mysql基本查询语句：

SELECT column1, column2, ... FROM table_name WHERE condition

mysql排序查询语句：

SELECT column1, column2, ... FROM table_name WHERE condition ORDER BY column1 [ASC|DESC], column2 [ASC|DESC], ...

mysql聚合查询语句：

SELECT SUM(amount), AVG(amount) FROM orders;

mysql分组查询语句：

SELECT column1, column2, ... FROM table_name WHERE condition GROUP BY column1, column2, ... [HAVING condition];