Create foreign keys on Table Creation Only?
I've searched far and wide for a resource that clearly explains how to create a foreign key without success. I can't find the term "foreign key" in phpMyAdmin. I downloaded two other programs, MySQL Front and SQLyog, and I haven't yet found a "Create Foreign Key" command on either one.
The MySQL Manual says:
"You can create a foreign key by defining a foreign key constraint when you create a table."
Does that mean you can only create a foreign key when you're creating a table? if you create a table without specifying a foreign key, then fill it with data, you're out of luck?
To test it, I created a new table in phpMyAdmin, searching for the "Create Foreign Key" command. No luck.
What's the magic secret?