mysql - 1062 Error (duplicate entry) with `ALTER IGNORE TABLE ADD PRIMARY KEY` query -

mysql - 1062 Error (duplicate entry) with `ALTER IGNORE TABLE ADD PRIMARY KEY` query -

- August 15, 2013

as know docs , other questions such query should silently drop rows duplicated id. mysql throws error:

this phpmyadmin output.

why mysql did not dropped rows duplicated id? ideas?

looks looked in wrong docs. looked @ 5.1 version docs , have 5.5 version of mysql server.

in right docs mentioned:

so need consider using suggested set session old_alter_table=1 or find way remove excess rows table.

Comments