Hello everybody

I would like to know if an auto_increment key is necessarily a primary or secondary key of a relation (table)? And by the way how can I define a secondary key in MySQL?

thx, in advance

George Papadopoulos

A field created with the auto_increment feature must also be set as a Primary key.

To create a secondary key just use the CREATE [UNIQUE] INDEX syntax...