Hi there,
I have 3 primary keys on one of my tables and one of them is an auto_increment field.
How can I drop the primary key on the auto_increment field? When I try (with PHPMYAdmin) it tells me that there can only be one auto column and it must be defined as a key.
Also, now I can not delete any of the other primary keys as I get the exact same message (There can only be one auto column and it must be defined as a key)
any help?
-dr
I have 3 primary keys on one of my tables and one of them is an auto_increment field.
How can I drop the primary key on the auto_increment field? When I try (with PHPMYAdmin) it tells me that there can only be one auto column and it must be defined as a key.
Also, now I can not delete any of the other primary keys as I get the exact same message (There can only be one auto column and it must be defined as a key)
any help?
-dr