立即学习:https://edu.csdn.net/course/play/27328/362513?utm_source=blogtoedu
DQL 数据查询语言
select完整语法:
老师讲的知识点是重点,易上手的。延展性的语句还是去官方文档上看。
SELECT column_name1, column_name2
FROM table_name
[WHERE where_condition]
[GROUP BY {col_name | expr | position}, ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position} [ASC | DESC], ...
[WITH ROLLUP]]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]--选取的数据范围(分页)
select 8*9;
结果是72,把查询语句当成计算器来使用