Prev Next

MySQL Aliases

Aliases in MySQL are used to give a temporary name to a column or a table. They make it easier to read and understand complex queries. Aliases are created using the AS keyword.

Examples with Tamil Kings

1. Using Aliases for Columns

SELECT king_name AS 'King', reign_period AS 'Reign' FROM tamil_kings_auto_increment;

Code Explanation: This query renames the king_name column to 'King' and the reign_period column to 'Reign' in the output.

2. Using Aliases for Tables

SELECT t.king_name, t.reign_period FROM tamil_kings_auto_increment AS t;

Code Explanation: This query gives the tamil_kings_auto_increment table an alias 't', making it easier to reference in the query.

Best Practices

  • Use aliases to simplify complex queries and improve readability.
  • Always use meaningful aliases to make the query easier to understand.

Key Takeaways

  • Aliases provide temporary names for columns or tables.
  • They make complex queries more readable and manageable.
Prev Next