title: MySQL: use the id of the row being inserted in the insert statement itself
body: <p>I'm trying to some something like that:</p>
  
  <pre><code>INSERT INTO dir_pictures SET filename=CONCAT(picture_id,'-test');
  </code></pre>
  
  <p>picture_id is my primary key, auto-increment. Basically I'm trying to put the id of this insert statement, in the statement itself.</p>
  
  <p>I'm sure it can be done with some extra PHP code or using more than one statements, but I was wondering if there is a quick and easy way to do it in one shot.</p>
  
  <p>PS. The statement above always put '0-test'</p>