add foreign key to existing table if constraint fails code example

Example 1: mysql change foreign key

ALTER TABLE Orders
ADD FOREIGN KEY (PersonID) REFERENCES Persons(PersonID);

Example 2: foreign key type uniqu mysql

mysql > create unique index index_bar_id on foos(bar_id);
mysql > alter table foos add constraint index_bar_id foreign key (bar_id) references bars (id);