title: How to increment a field in mysqli
body: <p>I want to insert many lines, but in one column I would like it to increment. In my example I am setting a variable to 5000 and I would like it to increment by one, every time a line is added to the database.</p>
  
  <p>I will say now this has nothing to do with auto increment. There is a reason I need an incrementing field.</p>
  
  <p>Here is my insert query</p>
  
  <pre><code>$incrementField=5000;
  $query="INSERT INTO `table` (`incrementField`,`this`,`morestuff`)
      SELECT ?,`this`,`morestuff` FROM `someTable`";
  $stmt = $db-&gt;prepare($query);
  $stmt-&gt;bind_param('i',$incrementField);
  $stmt-&gt;execute();
  $stmt-&gt;close();
  </code></pre>
  
  <p>Where the ? is I would like it to increment.
  I have tried ?+1 ?.+1 and all kinds of permutations, but nothing seems to work.</p>