728x90
◆ 문법 순서
[ SELECT ] -> [ FROM ] -> [ WHERE ] -> [ GROUP BY ] -> [ HAVING ] -> [ ORDER BY ]
◆ 실행 순서 (불러들이는 순서)
[ FROM ] -> [ ON ] -> [ JOIN ] -> [ WHERE ] -> [ GROUP BY ] -> [ HAVING ] -> [ SELECT ] -> [ ORDER BY ]
728x90
'MYSQL' 카테고리의 다른 글
| MYSQL : Query 연습_2 (0) | 2023.04.19 |
|---|---|
| MYSQL : Query 연습_1 (0) | 2023.04.19 |
| MYSQL : Index (0) | 2023.04.18 |
| MYSQL : OREDER BY (0) | 2023.04.11 |
| MYSQL : JOIN 문 (0) | 2023.04.11 |