Collections:
Using Table Alias Names in MySQL
How To Define and Use Table Alias Names in MySQL?
✍: FYIcenter.com
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)
⇒ Query with a Left Outer Join in MySQL
⇐ Query with an Inner Join in MySQL
2017-12-31, 1500🔥, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...