ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'

Question

ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'

Navigation

#1 by (4 votes)

2

I'm trying to put id as the primary key but it gives this error:

ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'

mysql

asked by anonymous 17.07.2014 / 03:10

1 answer

Importing an objc control into swift: Error on the one hand (func) of my contole Increment and decrease value with slider

score 4 · Answer 1

4

Is there a line with a value of 0 or NULL in this field? If so, you'll need to update them earlier for some value greater than zero. You can go back to 0 later if you want.

17.07.2014 / 03:14