Select

SELECT
[ALL | DISTINCT | DISTINCTROW] {* | COLUMN_NAME}
[FROM table_name]
[WHERE condition]
[GROUP BY column_name]
[HAVING condition]
[ORDER BY column_name [ASC | DESC]]
[LIMIT {[offset,] row_count | row_count OFFSET offset}]

SELECT * FROM `table_name`;

SELECT `column1`, `column2` FROM `table_name`;

Aliases

SELECT `column1` AS c1, `column2` AS c2 FROM `table_name` AS t1;