MySQL Forums
Forum List  »  General

Re: Primary Key Bug with Multiples of Same Column
Posted by: Peter Brawley
Date: May 06, 2021 12:35PM

Syntax should be ...

id int unsigned primary key auto_increment,

In 5.7.33 ...

ALTER TABLE package_tracking DROP PRIMARY KEY;

.... elicits ...

ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key.

What is the result of ...

select version();

Options: ReplyQuote


Subject
Written By
Posted
Re: Primary Key Bug with Multiples of Same Column
May 06, 2021 12:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.