Re: relations between tables

[Michael T. Babcock]

Octavian Rasnita wrote:

Is MySQL able (like MS Access) to define permanent relations between tables?

For example, I want to define a master - child relation between 2 tables so
when deleting some entries from the master table to automaticly delete the
entries from the details table without specifying this in the query.

Search for "REFERENCES" in the MySQL manual; it only applies to InnoDB type tables though.

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php