foreign key how to ?

[castali]

how to create a foreign key with MySQL frony or MySQl center ?

I find nowhere a tool like access , normally you've just to browse in another table to choose the foreign key

is it possible to do it ?

thank you

[greenman]

I'm not familiar with those tools being a CLI junkie myself, but remember that the default MyISAM table type doesn't enforce foreign key constraints. You can add the syntax though ! Or you can use InnoDb tables, which do enforce referential integrity:

See the MySQL Manual - foreign keys

[castali]

thank you for the link

I have tried the scripts with foreign keys , but you are never shure reading the table that you have a foreign key or not

strange that you cannot directly drag and drop a column to create in visual mode a foreign key

thank you