Using Table Alias Names in MySQL

Q

How To Define and Use Table Alias Names in MySQL?

✍: FYIcenter.com

A

When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names as shown in the following select statement:

mysql> SELECT l.id, l.url, r.comment FROM fyi_links l 
   INNER JOIN fyi_rates r ON l.id = r.id;
+-----+-------------------+-----------+
| id  | url               | comment   |
+-----+-------------------+-----------+
| 101 | dev.fyicenter.com | The best  |
| 102 | dba.fyicenter.com | Well done |
| 103 | sqa.fyicenter.com | Thumbs up |
+-----+-------------------+-----------+
3 rows in set (0.00 sec)

 

SELECT Statements with JOIN and Subqueries in MySQL

⇒⇒MySQL Database Tutorials

2016-10-17, 179👍, 0💬