Duplicate entry key phpmyadmin

Asked Feb 05 '20 at 18:04

Active Feb 05 '20 at 18:11

Viewed 106 times

I'm trying to assign the primary key to a column called emailadress in phpmyadmin, and i've been getting the following error:

#1062 duplicate entry for key "PRIMARY"

This is the SQL-query it tried to run:

ALTER TABLE `dparts`  ADD `emailadress` TEXT NOT NULL  AFTER `surname`,  ADD   PRIMARY KEY  (`emailadres`(30)) KEY_BLOCK_SIZE = 30 USING BTREE;

I think it has something to do with the fact that I'm not using INT. But then again, why am I not allowed to use text instead of int? Can I get a primary key without having to use INT? If so, how?

edited Feb 05 '20 at 18:11

Dharman

30,962
25
85
135

asked Feb 05 '20 at 18:04

Samsunlu Ülkücü

Nothing to do with data type. Primary keys are unique as error says – P.Salmon Feb 05 '20 at 18:45
Do you have any clue on how to solve this? – Samsunlu Ülkücü Feb 05 '20 at 19:02
Dedupe before altering – P.Salmon Feb 05 '20 at 19:06
...and how does one do that? – Samsunlu Ülkücü Feb 05 '20 at 19:11
Fidn all duplicate and remove them https://stackoverflow.com/questions/854128/find-duplicate-records-in-mysql – nbk Feb 05 '20 at 19:54

Duplicate entry key phpmyadmin

0 Answers0