Hi,
I DESPERATELY need help!
This motor does't seem to have a gas pedal.. It takes a full 4+ seconds to
run! Only ~500 rows in table. I chopped a lot of group by ordering, etc
off.
SELECT d.DigIDsKey,d.Title,d.ValueEnglish,d.URL
FROM DigIDs AS d
WHERE d.DigIDsKey IN(22, 27, 84, 164, 272, 289,
PLEASE if anyone can help!! We are past deadline
Object: Retrieve rows from table D.
GIVEN:
1. MySQL ver 3.23.33 (but must run on 3.22.25!)
2. Table D is connected to tables E,F,K through tables dE,dF,dK.
3. Table D is connected to table L through tables dK then Lk.
D - dE - E
D - dF - F
D -
Bruce,
Thanks for your reply!
1- Yes I've tested using MySQL GUI 1.7.4 with the same results
2 - Don't know, will have to find out
3 - I'll find and check that too
Paul,
Have you tried the SQL from mysql to see wht it does outside of PHP? IS
the MySQL server configured to log all queries?
Hi,
I have several related database indexing questions:
1)In trying to run SHOW INDEX FROM table my client (MySQL GUI 1.7.4) just
hangs, or else this takes many minutes. MySQL 3.23.33 What could be wrong?
I tryed an ALTER TABLE index creation on this table a while ago. Could it
be tied up
Hi!
Note MySQL version: 3.23.33
I need to sort sql query results in a complex way. If you could please help
it would
be much appreciated. Thanks in advance!
I have 7 tables: 1 is a base table then 3 pairs of list and joiner tables
2,3; 4,5; and 6,7 where 2,4 and 6 are joiners between 1