creating foreign key in MySql

[tranquillo]

Hi...

I wanna know how to create a foreign key in mysql..

I tried this
alter table arbetsplats modify klubbID int foreign key;

it says I have an error in my syntax... and I guess I do.

-stefan

 

[sleipnir214]

Explicit foreign keys are not well supported in MySQL.

Read here:

http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html

Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[tranquillo]

aaah... thanks... :/

-stefan..