Re: duplicate key question

2007-06-23 Thread Steve Edberg
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

Re: duplicate key question

2007-06-22 Thread Chris W
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

Re: duplicate key question

2007-06-22 Thread mos
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