Re: Simpler Join: Komplette Tabelle wird gescannt
Hallo Gregor,
danke für das gut vorbereitete Beispiel.
In Deinem SQL fehlt im Prinzip eine WHERE Klausel oder ein ORDER BY an dem MySQL erkennen kann, wann LIMIT 5 zutrifft.
Probier mal
SELECT wetten.id
FROM wetten_wetten AS wetten
INNER JOIN wetten_wetten_teams AS wt1
ON wt1.wette = wetten.id
ORDER BY wetten.id
LIMIT 5
Grüße
Thomas
Subject
Views
Written By
Posted
1900
December 15, 2012 02:12PM
Re: Simpler Join: Komplette Tabelle wird gescannt
1055
December 15, 2012 02:55PM
1019
December 15, 2012 03:09PM
1021
December 15, 2012 07:30PM
1124
December 16, 2012 02:32AM
948
December 16, 2012 02:41AM
854
December 22, 2012 09:02AM
1082
December 22, 2012 09:29AM
861
December 22, 2012 09:46AM
944
December 22, 2012 10:28AM
925
December 22, 2012 10:53AM
1211
December 22, 2012 11:05AM
1378
December 22, 2012 11:17AM
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.