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];
以上是编程学习网小编为您介绍的“mysql查询语句的基本用法”的全面内容,想了解更多关于 mysql 内容,请继续关注编程基础学习网。

相关文章