SELECT Statement

SELECT is used to retrieve rows selected from one or more tables, and can include UNION statements and subqueries.

Syntax

SELECT
    [ALL | DISTINCT | DISTINCTROW ]
    [HIGH_PRIORITY]
    [STRAIGHT_JOIN]
    select_expr [, select_expr] ...
    [FROM table_references
      [PARTITION partition_list]]
    [WHERE where_condition]
    [GROUP BY {col_name | expr | position}]
    [HAVING where_condition]
    [ORDER BY {col_name | expr | position}
      [ASC | DESC]]
    [LIMIT {[offset,] row_count | row_count OFFSET offset}]

Examples

SELECT * FROM t1 INNER JOIN t2 ON t1.id = t2.id;

SELECT a, b, a+b FROM t1;

SELECT ... INTO

The SELECT ... INTO form of SELECT enables a query result to be stored in variables or written to a file.

See also INSERT, UPDATE.