ld clarify
this... ;)
Jordan Russell
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscri
I
upgraded the RPM...
Jordan Russell
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
4 | files.dir_id |1 |
|
+---++---+-+-+--+--+
+
Thanks very much in advance for any assistance.
Jordan Russell
-
Before posting, please check:
http://www.mysql.com/man
the time does add
up...
My real question is, why does MySQL not use any index to sort when LEFT JOIN
is used. (Refer to the EXPLAIN SELECT output at the end of my message.)
Jordan Russell
-
Before posting, please check:
http
You have no where clause, so no index is used.
Oops, missed this part.
Where exactly do I need a WHERE clause, and for what? The first query
doesn't have a WHERE clause and yet it appears to be using the "date" index.
Jord
;
SELECT name FROM dirs WHERE id=dir_id from last query;
Later I want to use a LIMIT of 100 or more so I don't think using the
multiple queries will be an option then...
Jordan Russell
-
Before posting, please check:
http
versing the column/table order; that didn't help either:
SELECT dirs.name, files.id FROM dirs, files where dirs.id=files.dir_id ORDER
BY files.date DESC LIMIT 1;
Jordan Russell
-
Before posting, please check:
http://www.mysq
!
SELECT files.id, dirs.name FROM files, dirs where files.dir_id=dirs.id
ORDER BY files.date DESC LIMIT 1;
Jordan Russell
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
ilar-sounding problems in the mailing list archive, but I
can't seem to find a working solution...
Thanks.
Jordan Russell
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m