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:
http://dev.mysql.com/doc/refma
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. Ho
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 s