column equals the value in the
modification column? I don't want to specify a specific id in either
of the columns.
TIA
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
recedence with
the comma operator and the join, I realized there was a
simple fix and that I had misinterpreted the section on the first read.
The revised query works.
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
db.tab_f WHERE tab_a.id = 'value' AND tab_a.id2 = tab_e.id2 AND tab_e.id3 =
tab_f.id3 LIMIT 1; <- this is ok
Why doesn't the original query work in MySQL 5.0? What do I need to do to
make it work?
TIA
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For l
y doesn't work - it finds ALL the rows in Project table and hence
repeats the sites..
I do have an index on the Site table, it is the Site_ID. The
Project.Site_ID is also indexed.
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
s query is now
frequently in the slow query log.
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Several of my DISTINCT searches are frequently showing up in the slow query
log. These queries use multiple table joins. Using EXPLAIN shows that the
queries are using the appropriate keys, as far as I know. Are DISTINCT
searches using multiple joins slow?
TIA.
Stephen P. Fracek, Jr.
[EMAIL
400 MB.
Any insights would be greatly appreciated.
TIA
Stephen P. Fracek, Jr.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
