Error 1852: Creating unique indexes with IGNORE requires COPY algorithm to remove duplicate rows
Error Code
SQLSTATE
Error
Description
1852
HY000
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_IGNORE
Creating unique indexes with IGNORE requires COPY algorithm to remove duplicate rows
Possible Causes and Solutions
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
PreviousError 1851: Adding foreign keys needs foreign_key_checks=OFFNextError 1853: Dropping a primary key is not allowed without also adding a new primary key
Last updated
Was this helpful?