title: MySQL - Find table from constraint name
body: <p>I have an error popping up that throws an error like:</p>
  <pre><code>IntegrityError: (999, &quot;Duplicate entry 'XXXXX' for key 'constraint_name_here_uniq'&quot;)
  </code></pre>
  <p>So I have the constraint name, is there an easy way to find out what table, columns are referenced in the mysql command line? It's a very large database and tried poking around a few tables with <code>SHOW CREATE TABLE</code> with no luck, I also tried <code>DESC &lt;constraint name&gt;</code> but that didn't work either.</p>