Table aliases in MySQL - Step-by-Step Execution

Concept Flow - Table aliases

Write SQL Query

↓

Assign Alias to Table

↓

Use Alias in Query

↓

Execute Query with Aliases

↓

Return Results Using Aliases

This flow shows how you write a query, assign a short name (alias) to a table, use that alias in the query, and get results.

Execution Sample

MySQL

SELECT c.name, o.order_date
FROM customers AS c
JOIN orders AS o ON c.id = o.customer_id;

This query selects customer names and their order dates using aliases 'c' for customers and 'o' for orders.

Execution Table

Step	Action	Alias Assigned	Query Part Using Alias	Result
1	Start parsing query	None	None	No output yet
2	Assign alias 'c' to table 'customers'	c	SELECT c.name	No output yet
3	Assign alias 'o' to table 'orders'	o	JOIN orders AS o	No output yet
4	Use alias 'c' and 'o' in JOIN condition	c, o	ON c.id = o.customer_id	No output yet
5	Execute query with aliases	c, o	SELECT c.name, o.order_date	Rows with customer names and order dates
6	Return final result set	c, o	Final output	[{"name": "Alice", "order_date": "2024-01-10"}, {"name": "Bob", "order_date": "2024-01-12"}]

💡 Query execution completes and returns rows using aliases for clarity and brevity.

Variable Tracker

Variable	Start	After Step 2	After Step 3	After Step 4	Final
Alias for customers	None	c	c	c	c
Alias for orders	None	None	o	o	o
Result set	Empty	Empty	Empty	Empty	[{"name": "Alice", "order_date": "2024-01-10"}, {"name": "Bob", "order_date": "2024-01-12"}]

Key Moments - 2 Insights

Why do we use aliases like 'c' and 'o' instead of full table names?

Aliases make queries shorter and easier to read, especially when joining multiple tables. See execution_table rows 2 and 3 where aliases are assigned and then used.

Can we use aliases without the AS keyword?

Yes, in MySQL the AS keyword is optional. You can write 'customers c' instead of 'customers AS c'. The execution_table shows 'AS' used for clarity but it's not required.

Visual Quiz - 3 Questions

Look at the execution_table, what alias is assigned to the 'orders' table at step 3?

A o

B c

C orders

D None

💡 Hint

Check the 'Alias Assigned' column at step 3 in the execution_table.

At which step does the query start returning actual data rows?

A Step 4

B Step 5

C Step 2

D Step 1

💡 Hint

Look at the 'Result' column in the execution_table to see when rows appear.

If we remove aliases, how would the query change in the execution_table?

A Result set would be empty

B Query would fail to run

C Alias Assigned columns would be empty

D Aliases would be assigned automatically

💡 Hint

Aliases are optional; removing them means no alias names appear in the 'Alias Assigned' column.

Concept Snapshot

Table Aliases in SQL:
- Use 'AS alias' or just 'alias' after table name
- Shortens table names in queries
- Useful in JOINs for clarity
- Example: FROM customers AS c
- Use alias to refer to table columns
- Makes queries easier to read and write

Full Transcript

This lesson shows how to use table aliases in SQL queries. You write a query and assign short names to tables using AS or just a space. Then you use these short names to refer to tables in SELECT, JOIN, and WHERE clauses. This makes queries shorter and easier to understand. The example query selects customer names and order dates using aliases 'c' for customers and 'o' for orders. The execution table traces each step from assigning aliases to returning the final result set. Key points include that aliases are optional but helpful, and they simplify writing and reading queries.