Qualifying table names for column references

[marklenel]

It is possible in MySQL to implicitly qualify the table names where columns are unique to a given table e.g.

SELECT
MyTable1.MyColumn1
FROM MyTable1 INNER JOIN MyTable2 etc.

can also be written as

SELECT
MyColumn1
FROM MyTable1 INNER JOIN MyTable 2 etc.

on the assumption that MyColumn1 is unique to the first table only.

Is there any effect on performance for either option?

 

[r937]

yes, it's possible, and no, there's no effect on performance

rudy

http://r937.com/

SQL Consulting