MySQL Order of Operations?

Question

Is there a definitive place to find order of operations for mySQL statements? Is the below order correct?

FROM clause WHERE clause GROUP BY clause HAVING clause SELECT clause ORDER BY clause

If this is the case, can I use a term defined in the SELECT clase (select first_name as "f_name") within the group by clause?

Thanks!

Answer 1

I assume you are interested in SELECT, according to the MySQL documentation the syntax is as follows

SELECT
[ALL | DISTINCT | DISTINCTROW ]
  [HIGH_PRIORITY]
  [STRAIGHT_JOIN]
  [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
  [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
select_expr [, select_expr ...]
[FROM table_references
[WHERE where_condition]
[GROUP BY {col_name | expr | position}
  [ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
  [ASC | DESC], ...]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]
[PROCEDURE procedure_name(argument_list)]
[INTO OUTFILE 'file_name' export_options
  | INTO DUMPFILE 'file_name'
  | INTO var_name [, var_name]]
[FOR UPDATE | LOCK IN SHARE MODE]]

Yes, you can use columns defined with AS in the GROUP BY clause.