Opened by ptk at 2004-06-08 16:02
User since
2004-05-15
33 Artikel
BenutzerIn
![[default_avatar]](/battie/theme/default/default_avatar.gif)
2004-05-15
33 Artikel
BenutzerIn
[quote=renee,09.06.2004, 13:01]bringt ein [sql]DISTINCT[/sql] was??
[sql]SELECT DISTINCT accesslog_id from accesslog WHERE accessdate >= "2004-01 -01 00:00:00" ORDER BY accesslog ASC;[/sql][/quote]
nein das bringt nichts, das wird sogar langsamer.
[sql]SELECT DISTINCT accesslog_id from accesslog WHERE accessdate >= "2004-01 -01 00:00:00" ORDER BY accesslog ASC;[/sql][/quote]
nein das bringt nichts, das wird sogar langsamer.
Code: (dl
)
1
2
3
4
5
6
7
8
9
10
11
12
ohne DISTINCT
EXPLAIN
table type possible_keys key key_len ref rows Extra
s_ticklist_ETR range zeit zeit 4 NULL 5008 Using where
mit DISTINCT
EXPLAIN
table type possible_keys key key_len ref rows Extra
s_ticklist_ETR range zeit zeit 4 NULL 5008 Using where; Using temporary