title: How to ignore a field in Database with java sql query Netbeans
body: <p>I have 5 rows in MS Access database one of them is Serial Number whose property is auto number I am trying to pass this query to the database to insert.</p>
  
  <pre><code>int s= sta.executeUpdate("INSERT INTO stockDB VALUES('"+name+"','"+size+"','"+quantity+"','"+price+"')");
  </code></pre>
  
  <p>In the database the Serial Number is the first column then the name,size,quantity and price.</p>
  
  <p>When I am trying to do the insert i get this error:</p>
  
  <blockquote>
    <p>[Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.</p>
  </blockquote>
  
  <p>I know i should put something in the first but what should i put it there?
  I tried to put the Serial Number at the last but the error was the same.
  What should i put in the query so that the sql accepts it but still genrates auto number in the database?</p>