title: MySQL: information_schema.columns bugs?
body: <p>Why <code>information_schema.columns</code> always duplicates the result? For instance,</p>
  
  <pre><code>SELECT column_name 
  FROM information_schema.columns 
  WHERE table_name = 'root_blocks'
  </code></pre>
  
  <p>I will get this,</p>
  
  <pre><code>column_name
  
  blc_id
  blc_email
  cat_id
  blc_created
  blc_updated
  blc_id
  blc_email
  cat_id
  blc_created
  blc_updated
  </code></pre>
  
  <p>The duplicates go unpredictable on other tables when I try to query through phpmyadmin.</p>
  
  <p>How can I make it not to duplicate?</p>
  
  <p>Thanks.</p>
  
  <p><strong>EDIT:</strong></p>
  
  <p><img src="https://i.stack.imgur.com/mQV00.jpg" alt="enter image description here"></p>