How to delete primary key (PK) in Mysql?

Question

I have the following table in Mysql:

The id column is primary key. I would like to remove the primary key from this table. How can I do this?

Thank you.

Answer 1

Run this query to remove the desired column:

ALTER TABLE `tabela` DROP `coluna`;

I see you’re a beginner in PT Stackoverflow, but is it really necessary to remove the primary key from your table? Analyze your case well, it is necessary to differentiate the records, so having something that makes them really unique, extremely important and necessary to UPDATES and DELETES, each case is a case, but before removing it, see if this is really necessary as I have already said.

And if you just want to make one SELECT so that this column doesn’t appear, it’s simple, just send a: SELECT nome, profissao, nascimento, sexo, peso, altura, nacionalidade FROM tabela WHERE...

Finally, to just remove the primary key function you must perform these two querys:

//Você deve primeiro remover a propriedade de AUTO_INCREMENT e depois
//remover a chave primária

ALTER TABLE tabela MODIFY coluna INT NOT NULL;
ALTER TABLE tabela DROP PRIMARY KEY;

For it to become a primary key, just run:

ALTER TABLE tabela MODIFY coluna INT NOT NULL PRIMARY KEY AUTO_INCREMENT;