mysql - ALTER IGNORE ADD INDEX removed in mysql 5.7.4 - What to use instead? This may help: Rename the existing table and create a new table. Use insert ignore to copy data from old table to new table.