title: Obtain "next to be used" id for a table
body: <p>I have a table with 2 int type columns: one auto increment and primary, while the other is just not null.</p>
  
  <p>now, whenever a record is inserted into the tale, the first auto-increment column gets a unique and new id. What I want is that this new ID value to be also inserted to the other column, in the same insert statement.</p>
  
  <p>How can a achieve this? Plz help...</p>
  
  <p>thnx in advance :)</p>