title: SQL Concatenation Not Incrementing
body: <p>I am trying to insert data into my SQL table and concatenate two columns at the same time.</p>
  
  <pre><code>insert into users (cid, username) values (concat('b', id), 'testusername');
  </code></pre>
  
  <p>The ID column is set to auto_increment and when I run the above code it places '1' in the ID column and it places 'testusername' in the username column. This is great. However, the cid column reads 'b0'. I'd like it to say 'b1'. </p>
  
  <p>Furthermore, if I run the statement again, I'd like row 2 to show the value 'b2' in the cid column, but it repeats the value 'b0'. How do I get the cid column to correctly read the incrementing ID column during concatenation?</p>