Another Defining Relationships in MySQL Question

2002-11-08 Thread tmb 
In MS Access you define relationships between Key ID
fields by dragging a line on the screen from the
parent table to the child table.

So, if you are enforcing referential integrity you
can not delete data that is referred to by another
table or mess up the basic db structure... (think I
have this about right :)

When you first create a db in MySQL... how do you tell
MySQL which Key field in table A is related to a field
in table B?

Thanks for any help - tmb


__
Do you Yahoo!?
U2 on LAUNCH - Exclusive greatest hits videos
http://launch.yahoo.com/u2

-
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

Re: Another Defining Relationships in MySQL Question

2002-11-08 Thread Michael T. Babcock 
tmb wrote:


In MS Access you define relationships between Key ID
fields by dragging a line on the screen from the
parent table to the child table.
 


Read up on referential integrity and InnoDB tables in the online docs at 
http://www.mysql.com/doc/en

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