mysql查询语句的基本用法

2024年10月08日 建站教程

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];

本文链接:http://so.lmcjl.com/news/14900/

展开阅读全文
相关内容