you are at Encyclopedia of SQL >> SELECT
SELECT
In connection with FROM it chooses columns from given table ( tables )Syntax
SELECT `column_name`
FROM `table_name`
Asterisk (*) placed after SELECT chooses all columns from table
Example
Display names and surnames
name | surname | age |
---|---|---|
Paweł | Kowalski | 3 |
Piotr | Janik | 7 |
Michał | Nowak | 13 |
query
SELECT `name`,`surname`
FROM `people`
result
name | surname |
---|---|
Paweł | Kowalski |
Piotr | Janik |
Michał | Nowak |