The table has been created using int not null default 0 primary key auto_increment ;
Why can't I drop the primary key now ?
alter table myqabank DROP PRIMARY KEY ;
ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key
any thoughts ?
tx.