Home remove duplicate rows in a table. Error on Ignore TABLE statement
Reply: 0

remove duplicate rows in a table. Error on Ignore TABLE statement

Dick
1#
Dick Published in 2017-12-07 18:09:23Z

I know this question have been asked more than once on this forum. I have been flowing the answer from this question:

MySQL: ALTER IGNORE TABLE gives "Integrity constraint violation"

I have the Engine changed to MyISAM

However, when I run:

ALTER IGNORE TABLE table ADD UNIQUE INDEX dupidx (field);

I get this as a response:

    Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to 
use near 'IGNORE TABLE table ADD UNIQUE INDEX dupidx (field)' at line 1

And yes, I did change the table and field names in the query to match my table.

EDIT:

The only real deference is that I am adding the index to a DATETIME field. Could that be what is giving me grief?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.298055 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO