MySQL數據庫中SELECT語句快速精細掌握

本文針對MySQL數據庫中的SELECT語句快速精細掌握。

MySQL中SELECT語句的基本語法是：

SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] 
[SQL_BIG_RESULT] [HIGH_PRIORITY] 
[DISTINCT|DISTINCTROW|ALL] 
select_list 
[INTO {OUTFILE|DUMPFILE} 'file_name' export_options]
 [FROM table_references [WHERE where_definition]
 [GROUP BY col_name,...] [HAVING where_definition] 
[ORDER BY {unsighed_integer|col_name|formura} [ASC|DESC],...] 
[LIMIT [offset,] rows] [PROCEDURE procedure_name]]