In a SELECT query, the purpose of using column aliases (the AS keyword) is to make the output of your query more readable, professional, and useful.
Here are the four main reasons why we use them:
1. Renaming Calculated Columns
When you perform a calculation (like price * 0.8), MySQL doesn't have a natural name for that column. Without an alias, the header in your result would look like the math formula itself: price * 0.8.
- Without Alias:
price * 0.8 - With Alias:
sale_price(Much clearer!)
2. Improving Readability
Database column names are often short or technical (e.g., cust_id, u_email). Aliases allow you to present data in a way that makes sense to humans or business reports.
- Example:
SELECT name AS product_name
3. Disambiguation in Joins
When you start working with multiple tables, you might have a name column in a customers table and a name column in a products table. Aliases help you distinguish between them in the final result set so you don't have two columns both labeled "name".
4. Compatibility with Applications
If you are writing a program (in Python, Node.js, etc.) that fetches data from a database, the code often looks for specific keys. If your database column is named prod_desc but your frontend code expects description, you can use an alias to bridge that gap:
SELECT prod_desc AS description FROM products;
Pro Tip: In the AS keyword, if your alias contains spaces, you should wrap it in quotes:
SELECT name AS "Full Product Name" FROM products;You've already successfully used aliases in your command history for retail_price and sale_price. Great job!
