title: Autoincrement ID with a prefix
body: <p>I'm designing a table 'employees', which contains an primary key which is auto increment and represents an ID of the employee.</p>
  
  <p>I want to prefix the ID with an number designating the city: city 1: 1, city 2:2, etc.</p>
  
  <p>So the IDs should look like xyy where x represents the city and yy the ID of the employee.</p>
  
  <p>When I'm adding new employee I'm selecting the city x, and I would like to yy values to auto increment.</p>
  
  <p>Is that possible using SQL commands?</p>