Alias in MySQL - MySQL Tutorials | Letsfindcourse

Learn about alias in MySQL with example | MySQL Tutorial | Learn SQL

Aliases in MySQL is used to give a temporary name to a table or a column in a table for the purpose of a particular query. It works as a nickname for expressing the tables or column names. It makes the query short and neat.

It is very useful when the table or column name is not user-friendly in real-time. It makes the name of a column more readable. MySQL aliases can exist only for the duration of a query.

For Example - SELECT column_name AS alias_name FROM table_name;