Results 1 to 10 of 10
May 12, 2004, 11:14 #1
- Join Date
- Jan 2004
- 0 Post(s)
- 0 Thread(s)
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?