title: How do i insert the next value for an auto increment filed duing Prepared Statemenet insert operation?
body: <p>I am using Mysql as database </p>
  
  <pre><code>mysql&gt; desc customer;
  +-------------------+-------------+------+-----+---------+----------------+
  | Field             | Type        | Null | Key | Default | Extra          |
  +-------------------+-------------+------+-----+---------+----------------+
  | customer_id       | int(11)     | NO   | PRI | NULL    | auto_increment |
  | name              | varchar(20) | YES  |     | NULL    |                |
  
  PreparedStatement insertpsmt = connection.prepareStatement("insert into customer values(?)");
  insertpsmt.setInt(1, "testname");
  </code></pre>
  
  <p>How do i insert the value for customer_id  as  this is a auto_increment field ??</p>