Aliases

This YouTube video was created by Steve Griffith.

Aliases are use to give a table or column a temporary name. They can also make columns and table names more readable. The AS keyword is used to set the alias, comes between the table or columns name and the alias name.

Note

Backticks (`) should be use for table, column and alias names that have spaces in them.

# Setting Aliases on the table columns
SELECT `movie_title` AS `Movie Title`, `director` AS `Movie Director`
FROM `movies`;

Try it yourself on DB Fiddle