[SQL] Assign FOREIGN KEY to an existing column

[kito2]

Hello,

I have been digging on the web to assign a foreign key to an existing column.

The example is: Having banned_id at account_bans, which should refers to id at players.

ALTER TABLE account_bans
ADD FOREIGN KEY (banned_id) REFERENCES Players(id);

But I can't make it work on the server, just works on my localhost:

It is giving that error.

Can someone help?

Thanks!

 

[Codex NG]

Maybe this will help?
SQL FOREIGN KEY Constraint

 

[kito2]

From that site, exactly that one, managed to create the specific query and worked on my localhost, but on main server didnt. I expect it may be a user problem, maybe permission problem as far as I have read on other sites.

 

[Codex NG]

From that site, exactly that one, managed to create the specific query and worked on my localhost, but on main server didnt. I expect it may be a user problem, maybe permission problem as far as I have read on other sites.

It could be your mysql version, I remember sharing code with someone and having to place the column names in ` ` so the query would execute.
You might want to compare the mysql/phpmyadmin versions, they might look the same but they could work completely differently.

 

[Codex NG]

Of course there is this as well.
How do I create a foreign key in SQL Server?

 

[kito2]

That one worked:

ALTER TABLE account_bans ADD CONSTRAINT account_bans_banned_id_FK FOREIGN KEY ( banned_id ) REFERENCES players(id)