[PHP] MySQL - setting relationships

[Denis L. Menezes]

hello friends,

I am a newbie at MySQL.

In MS Access we specifically set relationships. In MySQL, I have found no 
documentation regarding setting relationships. 

Is is that we do not need to set the relationships in MySQl and only matching the 
Field IDs in respectyive tables is suffecient?

Thanks
Denis

[PHP] MySQL - setting relationships

[Larry E. Ullman]

In MS Access we specifically set relationships. In MySQL, I have found 
no documentation regarding setting relationships.

Is is that we do not need to set the relationships in MySQl and only 
matching the Field IDs in respectyive tables is suffecient?

Current versions of MySQL do not have ways to constrain foreign keys 
unless you're using the InnoDB table type. This will change in later 
versions of MySQL. For the time being, you can still create your 
database as you otherwise would and perform a join across the tables.

Larry


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php