MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: why must i specify an index in query?
Posted by: Rick James
Date: July 02, 2015 09:47PM

You can use the same table twice ("self join") in a query by giving each instance an alias.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
why must i specify an index in query?
1756
Caleb Pitman
July 02, 2015 10:31AM
Re: why must i specify an index in query?
890
Peter Brawley
July 02, 2015 11:46AM
Re: why must i specify an index in query?
1544
Caleb Pitman
July 02, 2015 12:46PM
Re: why must i specify an index in query?
1005
Peter Brawley
July 02, 2015 01:58PM
Re: why must i specify an index in query?
1020
Caleb Pitman
July 02, 2015 02:49PM
Re: why must i specify an index in query?
943
Rick James
July 02, 2015 09:47PM
Re: why must i specify an index in query?
910
Peter Brawley
July 02, 2015 10:36PM
Re: why must i specify an index in query?
1050
Caleb Pitman
July 03, 2015 08:10AM
Re: why must i specify an index in query?
941
Peter Brawley
July 03, 2015 03:06PM
Re: why must i specify an index in query?
908
Rick James
July 03, 2015 09:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.