title: sql error: Unknown column in 'field list' on insert
body: <p>I am trying to insert an entry into a table, using Java, and it returns me an error "Unknown column XX in 'field list'".</p>
  
  <p>For example: I have created a table using this line:</p>
  
  <pre><code>CREATE  TABLE `dbcs`.`born in` (`person` VARCHAR(100) ,`year` INT ,`prob` FLOAT);
  </code></pre>
  
  <p>the table was created successfully.</p>
  
  <p>when I try to insert something to the table, it shows me the error. for example, the command:</p>
  
  <pre><code>INSERT INTO `dbcs`.`born in` VALUES (`Alanis Morissette`,1974,1.0)
  </code></pre>
  
  <p>will generate the error:</p>
  
  <blockquote>
    <p>Unknown column 'Alanis Morissette' in 'field list'</p>
  </blockquote>