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, 5
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?
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 - dK
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 wit
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 and
THANK_YOU!
I was modifying entries for a joiner table without checking to see tif they
were already present!
> Subject: RE: Duplicate entry error??
>
>
> > Hi,
> >
> > You have a unique key defined which includes Ekey and another field (the
> key
> > 2 mentioned in the error message), and the
Thanks in advance for your help!
How does one replace a single field value when the value repeats? I tryed
the following and get an error message "Duplicate entry '88-252' for key 2"
UPDATE DKWords SET EKey='252' WHERE EKey='13'
What is wrong?
Paul
-
