More Primary / Auto-adding unique IDs per one table in MySQL?

Question

Hi,

Is it possible to have two and more primary/automatic-adding unique IDs per one table in MySQL? For example:

Primary Key (INT,11);shop_id;invoice_id

1;200;2001
1;201;2011
2;200;2002
2;201;2012

Is it possible to set this to MySQL table ? -> So there are more primary keys for some other value in the table.. ?

I am looking for more auto-increments in one table.

Answer 1

You can only have a single AUTO_INCREMENT column per table in MySQL. You can only have a single PRIMARY key in a table in MySQL, but it can be a composite key and consist of more than one column.

But from the example you gave, it looks like you're asking for something different. Can you clarify?

Answer 2

are you looking for AUTO_INCREMENT on a secondary column in a multiple-column index? you can do this for MyISAM tables.