SQL 常用语句总结
SQL 常用语句总结(基于MySQL)
基本用法
SELECT a.column_name1, a.column_name2, … , b.column_name1, b.column_name2 …
FROM table_name1 a
(LEFT/RIGHT/OUTER/INNER(default)) JOIN table_name2 b
ON a.key = b.key
WHERE <some conditions>
GROUP BY <some columns>
HAVING
原创
2021-11-28 07:12:48 ·
259 阅读 ·
0 评论