Here is the clause defining a foreign key constraint.
CONSTRAINT `contact_id_fk` FOREIGN KEY (`contact_id`) REFERENCES
This clause does not end with a comma since it is the last clause in
the create table statement.
This clause works perfectly in the first table in which it is used,
provided the conts table is created first.
In the second and third tables where it is used, it generates an error
like the following:.
ERROR 1005 (HY000) at line 121: Can't create table '.\test\prods.frm'
This isn't a very informative error message. What does it mean? Why
would the foreign ...