SQL ALIASES example – Learn how to create temporary name / readable name for columns or tables in MySQL database with example using AS keyword in SQL and important points about it. Giving a custom name to any column or table is known as alias.
lets say we have a column “title” in the BOOKS table and you want to see the list of books available in the table. So, we can write title as “Book Title” in the SQL SELECT clause. Book Title is the alias of column “title” and is more readable. Here is the query example for alias : “Select Title AS ‘Book Title, price FROM BOOKS;”.
Points to Notice:
In SQL database, aliases can be used to create a temporary name for columns name or tables.
- Column Aliases make column headings in result set easier to read.
- Table Aliases shorten SQL to make it easier to read when performing a join operation.
SQL Alias Syntax
SQL syntax for aliasing a Column
To give the column a custom name we write query like [ “column name” AS “whatever custom name you want to give”]
SELECT [column_name] AS [alias_name] FROM [table_name];
SQL syntax for aliasing a Table
SELECT [column_names] FROM [table_name] AS [alias_name];
Points to notice:
- If the alias name contains spaces, enclose the alias name in quotes.
- Spaces are allowed while aliasing a column name, but it is not good practice to use spaces.
- The alias name is only valid within the scope of the statement. Meaning, you query for alias and see the alias name in the result set and then gone.
SQL Alias example for column of BOOKS Table
SELECT TITLE AS ‘BOOK TITLE’, PRICE FROM BOOKS;
|PRIDE AND PREJUDICE||506|