Alias

Also known as · AS

A temporary name for a column or table, given with the AS keyword, for example AVG(rental_rate) AS avg_rate or FROM film f. Because WHERE runs before SELECT, an alias defined in SELECT cannot be used in WHERE.

sql
SELECT CONCAT(first_name, ' ', last_name) AS full_name
FROM customer c;

When to use

Used throughout PS 03 and PS 04 (f for film, AS full_name), and MySQL requires one on a Derived Table (AS customer_rentals in PS 04 Q1).

See PS 03.

Appears in