mos wrote:
Chris,
You probably want to know the specific table, so I wonder if it
shows up in the MySQL error logs? Of course you can dump the database
structure and look for key x by doing:
mysqldump --no-data --skip-opt --skip-comments --compact
and redirect it out to a text file.
At 10:19 PM -0500 6/22/07, Chris W wrote:
when you get a duplicate key error it says something to the effect
of Duplicate entry 'xyz' for key x
What I want to know is how to find out what table fields are part of key x?
'show index' is what you want, I think:
At 09:19 PM 6/22/2007, you wrote:
when you get a duplicate key error it says something to the effect of
Duplicate entry 'xyz' for key x
What I want to know is how to find out what table fields are part of key x?
--
Chris,
You probably want to know the specific table, so I wonder if it
This is somewhat related to my last question RE conflicting procedure
argument names, but in regards to multi-row inserts...
suppose the following procedure:
DROP PROCEDURE IF EXISTS sp_ImportedUpdate |
CREATE PROCEDURE sp_ImportedUpdate ()
DETERMINISTIC CONTAINS SQL MODIFIES SQL DATA