Error trying to create table in mysql - Multiple Primary key defined

Question

I’m creating a database and one of the tables doesn’t want to be created with prayer.

The following error appears:

Error Code: 1068. Multiple Primary key defined

What’s wrong with my code?

CREATE TABLE `controle_ferramentas` (
  `requisitante_cpf` int NOT NULL primary key,
  `data_hora_emprestimo` datetime DEFAULT NULL,
  `data_hora_devolucao` datetime DEFAULT NULL,
  `area_producao_cultivo_id` int NOT NULL primary key,
  `almoxarifado_id` int NOT NULL primary key,
  FOREIGN KEY (`area_producao_cultivo_id`) REFERENCES `area_producao_cultivo` (`id`),
  FOREIGN KEY (`almoxarifado_id`) REFERENCES `almoxarifado` (`id`),
  FOREIGN KEY (`requisitante_cpf`) REFERENCES `funcionarios` (`cpf`)
);

Answer 1

Your code contains:

area_producao_cultivo_id int NOT NULL (primary key), 
almoxarifado_id int NOT NULL (primary key)

If the error says "Multiple Primary key defined", I believe it can only have a "Primary key" - "primary key".

Try to leave only one primary, usually I leave only the "id" at the beginning as Primary key.

Answer 2

Your error is giving 'Multiiple Primary key'' because per table there can only be a primary key, if you have the requester’s Cpf then this will be a primary key and for the other fields you want to turn into primary key, for the sake of organization, would be from other tables, and to select everything you use select and Where. By definition there can only be one primary key per table.

You may have several constraints Unique but Primary key only one per table.

I hope I’ve helped!!