Wednesday, 18 September 2013

Cant define a Foreign Key in PHPMyAdmin

Cant define a Foreign Key in PHPMyAdmin

Setting up a database in PHPMyAdmin and i have two tables, Foo and Bar. I
want to use the Primary Key from Foo as a Foreign Key in Bar, but when i
go to the relational view it says "No index defined!". Any ideas why?
Also, if i set this up, does that mean that as an Foreign Key, Foo will
have its data auto imported and updated to Bar every time a new row is
added?

No comments:

Post a Comment