title: MySQL Trigger to auto insert week of the year and 001 (autoincrement)
body: <p>I'd like to set a MySQL trigger to set an ID number with the following format:</p>
  
  <p>week of the year + 001</p>
  
  <p>For example 09002 would be the 9th week of the year and 002 would be the second order for that week.</p>
  
  <p>Any help, comment would be greatly appreciated, Thanks.</p>