TIP: Always backup your database before making changes!
The mySQL Syntax:
ALTER IGNORE TABLE ps_customer ADD UNIQUE INDEX(field1, field2)
Example Code:
ALTER IGNORE TABLE ps_customer ADD UNIQUE INDEX(email)
TIP: Always backup your database before making changes!
The mySQL Syntax:
ALTER IGNORE TABLE ps_customer ADD UNIQUE INDEX(field1, field2)
Example Code:
ALTER IGNORE TABLE ps_customer ADD UNIQUE INDEX(email)