title: MySql AUTO_INCREMENT in INNODB Engine as second column
body: <p>i have a very annoying problem at this moment. i want a table with the following specification:</p>
  
  <pre><code>CREATE TABLE  `test` (
     `client` INT NOT NULL ,
     `id` INT NOT NULL AUTO_INCREMENT ,
     `test` INT NOT NULL ,
     PRIMARY KEY (  `client` ,  `id` ) ,
     INDEX (  `test` )
  ) ENGINE = INNODB;
  </code></pre>
  
  <p>you can see, that i have a primary key with 2 columns. now i want that the id auto_increment column only increments in order to the first column. for example:</p>
  
  <pre><code>## client/id ##
  1/1 
  1/2 
  1/3
  2/1
  2/2
  2/3
  </code></pre>
  
  <p>etc.</p>
  
  <p>is this really impossible with innodb? i need innodb because of the transactional features.</p>