Aliases In MySQL

In MySQL, Aliases are used to provide alternative names for columns or tables in a query result.

This can make the output more readable or provide shorter names for complex expressions.

Benefits of Aliases in MySQL:

Aliases help manage and improve the readability of SQL queries by providing descriptive names for columns and tables.
Aliases are particularly useful in complex queries involving multiple tables or calculated columns.
Aliases allow for self-documenting queries, making it easier for developers and analysts to understand and maintain the query.

Usage of Aliases in MySQL:

Aliases can be used in `SELECT`, `FROM`, `JOIN`, and other clauses of SQL queries where column or table names are referenced.
Aliases are optional but highly recommended for complex queries to manage and improve the readability of SQL queries.

Types of Aliases In MySQL:

Column Aliases In MySQL:

We can use aliases to provide alternative names for the columns in the result set. This is particularly useful when dealing with expressions or calculated values.

Column Aliases are specified after the `columnName` followed by the `AS` keyword.

Syntax:

SELECT 
product_name AS "Product Name", 
category AS "Product Category" 
FROM products;

The above query will return columns named "Product Name" and "Product Category" instead of the original column names.

Table Aliases In MySQL:

Table aliases are used to provide a shorthand notation for table names in a query, especially when dealing with multiple tables in a join.

Table Aliases are specified after the `tableName` followed by the `AS` keyword.

Syntax:

SELECT p.product_name, p.category, o.purchase_by
FROM products AS p
JOIN orders AS o ON p.product_id = o.product_id;

Here, "p" and "o" are aliases for the "products" and "orders" tables, respectively. This makes the query more concise and easier to read.

Using Aliases with ORDER BY In MySQL Table:

Aliases can be used in the ORDER BY clause to refer to the result columns directly.

Example:

SELECT product_name, category, price AS product_price
FROM products
ORDER BY product_price ASC;

The above query will return columns such as "product_name", "category" and "product_price" alias is used in the ORDER BY clause to sort the results based on the calculated price.

<-- Where

Count, Sum, Avg -->