phpMyAdmin, MySQL and Foreign Keys

JamesU2005 · 15 Oct 2007 at 20:11

Coming from a Microsoft Access mindset, I've been a bit confused with how and whether I can do/need Foreign Keys in a MySQL database.

I'm starting to learn it slowly but I seem to be going round in circles with foreign keys and MySQL.

Is there some other method?

Sorry if this is a kind of "noobish" post but as I said I'm trying to change my mindset.

Cheers for any help.

Beansprout · 15 Oct 2007 at 20:28

You can't enforce referential integrity with MyISAM tables, but InnoDB will do it

JamesU2005 · 15 Oct 2007 at 22:18

Thanks.

Just need to learn how to do this in phpMyAdmin.

Any tutorials for foregin keys for InnoDB in phpMyAdmin?

Moredhel · 16 Oct 2007 at 08:56

I've never found a way to do it in PHPMyAdmin. I generally use the mysql cli to do it.

ALTER TABLE foo ADD CONSTRAINT etc..

JamesU2005 · 16 Oct 2007 at 10:28

I've given up, seems far too hard for me!

What is be best to do something else rather than Foreign Keys?