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
-
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
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
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
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
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 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
