6.10. SQL Select From

../../_images/sql-select.png

6.10.1. All Columns

SELECT * FROM astronauts;

6.10.2. Selected Columns

SELECT `firstname`, `lastname`
FROM astronauts;

6.10.3. Column Name Aliases

SELECT firstname AS fname,
       lastname AS lname
FROM astronauts;

SELECT firstname,
       lastname,
       previous_job as career
FROM astronauts;