title: MySQL: #1054 - Unknown column 'product_type' in 'field list', but there is no such column in the query
body: <p>I am trying to execute the following insert query.</p>
  
  <pre><code>INSERT INTO product_records( p_id, color, brand, product_line ) 
  VALUES (
  '8',  'test',  'test',  'test'
  )
  </code></pre>
  
  <p>but it says,</p>
  
  <pre><code>MySQL: #1054 - Unknown column 'product_type' in 'field list'
  </code></pre>
  
  <p><strong>EDIT:</strong>
  Table- <strong>product_records</strong></p>
  
  <pre><code>Field   Type    
  p_id    varchar(10)
  color   varchar(32)  
  brand   varchar(15)  
  product_line    varchar(32)
  </code></pre>
  
  <p>But there is no column 'product_type' in table  <code>product_records</code>. whats wrong here, i have no idea!</p>