[SOLVED] Auto Increment on multiple primary keys from different tables - InnoDB

[yandoo]

Hi there,

 

just wanted to know if its ok to have multiple primary keys of different tables (int's) all with auto increment feature?? Is this ok to do or am i like to run into problems if i go down this path??

 

Thanks Smiley

[Barand]

A table can have ONE primary key

 

A table can have ONE auto_increment column which must be defined as a key (so it is normally the PK)

 

Each table should have a primary key.

 

If you want to make each table's PK an auto_inc column then that's fine.

[yandoo]

Brilliant thanks!

I was worried that interactions of different records from different tables with auto number Primary keys may some how get confussed...

 

I know this probably seems like a silly question but is there some way i could have a auto incremented code?? Like Product1, Product2, etc.) as  primary key of a table???

 

Only auto increment in phpmyadmin only works with INT...not VARCHAR.. 

 

Thanks

[Barand]

auto_inc must be numeric - TINYINT, SMALLINT, INT

[yandoo]

Cool,

 

Thanks

[Aureole]

auto_inc must be numeric - TINYINT, SMALLINT, INT

What about MEDIUMINT?