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?