title: In MySQL, how can I use the autoincrement value in another column at the time of the INSERT?
body: <p>I am looking to have the automagically set autoincrement included in another column during the insert.  For example in a table where ID is the autoincrement and Name is the other column, I'd like to do something like</p>
  
  <pre><code>`INSERT INTO Names (Name) VALUES (CONCAT("I am number ",ID));`
  </code></pre>
  
  <p>Currently, I do the INSERT without Name, then I have to immediately after do an UPDATE using $mysqli->insert_id.  </p>
  
  <p>I don't want to query the table in advance because, as small a time as it may be, another record could get inserted between getting the next autoincrement value and the insertion.  A trigger could work, but it seems like overkill.  I just want to know if I can reference the autoincrement within the insertion.</p>
  
  <p>Many thanks!</p>