Column aliases in MySQL - Step-by-Step Execution

Concept Flow - Column aliases

Write SELECT query

↓

Specify column names

↓

Add AS alias for columns

↓

Execute query

↓

Result shows alias as column header

This flow shows how you write a SELECT query, add aliases to columns, and get results with those aliases as headers.

Execution Sample

MySQL

SELECT first_name AS name, age AS years FROM users;

This query selects first_name and age columns from users table and renames them as name and years in the output.

Execution Table

Step	Action	Query Part	Effect	Output Column Names
1	Start query	SELECT	Prepare to select columns
2	Select column	first_name	Select data from first_name column	first_name
3	Apply alias	first_name AS name	Rename first_name to name in output	name
4	Select column	age	Select data from age column	name, age
5	Apply alias	age AS years	Rename age to years in output	name, years
6	Execute query	FROM users	Fetch data from users table	Columns: name, years with data
7	Return result	Result set	Show data with aliased column headers	name, years

💡 Query execution ends after fetching and displaying aliased columns.

Variable Tracker

Variable	Start	After Step 3	After Step 5	Final
Output Column Names		name	name, years	name, years

Key Moments - 2 Insights

Why does the output show 'name' instead of 'first_name' after aliasing?

Because in step 3 of the execution_table, the alias 'name' replaces 'first_name' as the column header in the output.

Can I alias multiple columns in one query?

Yes, as shown in steps 3 and 5, each selected column can have its own alias which will appear in the final output headers.

Visual Quiz - 3 Questions

Look at the execution_table at step 5, what are the output column names after applying the second alias?

A name, age

B name, years

C first_name, years

D first_name, age

💡 Hint

Check the 'Output Column Names' column in row 5 of the execution_table.

At which step does the query start fetching data from the users table?

A Step 2

B Step 4

C Step 6

D Step 7

💡 Hint

Look for the 'FROM users' action in the execution_table.

If you remove the alias 'AS years' from age, what would be the output column name at step 7?

A age

B years

C name

D first_name

💡 Hint

Refer to how aliases change output column names in the variable_tracker and execution_table.

Concept Snapshot

SELECT column_name AS alias_name
Use AS to rename columns in query output
Aliases appear as column headers in results
Multiple columns can have aliases
Aliases improve readability without changing data

Full Transcript

Column aliases let you rename columns in your query results. You write a SELECT statement, choose columns, and add AS followed by the alias name. When the query runs, the output shows the alias instead of the original column name. This helps make results easier to read or understand. You can alias one or many columns in the same query. The alias only changes the output header, not the actual data or table structure.