Posts

Showing posts from March, 2017
One thing that would have helped me when I was first learning to program is just a tutorial on how to read documentation.   There are so many tutorials out there that explain the documentation in english but nothing that actually teaches you how to read the documentation.  The documentation is a language unto itself: 14.2.9 SELECT Syntax 14.2.9.1 SELECT ... INTO Syntax 14.2.9.2 JOIN Syntax 14.2.9.3 UNION Syntax 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 [PARTITION partition_list ] [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 OFF