Re: How to link tables in MySQL

[Michael T. Babcock]

John Meyer wrote:

AFAIK, MySQL doesn't have any sort of referential integrity checks with
fields. conceptually, you can do it, and write your program to force it,
but the database itself doesn't have it.

Or you can use REFERENCES with InnoDB tables; http://www.mysql.com/doc/en ... search for "innodb referential integrity".

... this has nothing to do with your SELECT queries though; just inserts, updates and deletes.

--
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