[MySQL] alter table FK

programming
1

hi guys,
I want to alter table to add FK in my table, but for some reason it’s not working
the code that i’m using is below:

ALTER TABLE profile(
add CONSTRAINT fk_myID
FOREIGN KEY (my_id) REFERENCES account(my_id);
)