title: MySQL Trigger AFTER INSERT to auto-increment a column
body: <p>I'm sort of a newbie with MySQL and DBs in general so bear with me :)</p>
  
  <p>I have a table - tblfolders which has a field 'barcodeID' which is an INT that I need incremented by 1 each time a new row is inserted into the table. I can't make this an auto-increment field because I already have my 'id' field auto-incrementing. </p>
  
  <p>I tried doing this with an AFTER INSERT trigger but I keep getting an error: "Can't update table 'tblfolders' in stored function/trigger because it is already used by statement which invoked this stored function/trigger."</p>
  
  <p>Any suggestions on how I can auto-increment this field on an insert into my table? </p>
  
  <p>Thanks!</p>