6.10. SQL Select From
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;