Thomas,
Wednesday, July 10, 2002, 1:15:35 PM, you wrote:
TEJ> If i have two seperate mySQL Tables in my database,
TEJ> with some information.. and i would like to connect
TEJ> the two tables so as to get Relevant Data picked up
TEJ> from the relevant Table and it's relevant fields.
TEJ> Do we need to use a Foriegn/Primary key for this
TEJ> purpose?
You can join several tables in SELECT statements without foreign keys,
f.e.
SELECT * FROM table1, table2 WHERE table1.column1=table2.column2;
Please, check the MySQL manual:
http://www.mysql.com/doc/M/u/Multiple_tables.html
Foreign keys are used for Referential Integrity ...
TEJ> If so, how do you use them? I coudln't find a
TEJ> suitable description on using the Foriegn Keys in the
TEJ> mySQL Manual.
http://www.mysql.com/doc/S/E/SEC446.html
http://www.mysql.com/doc/e/x/example-Foreign_keys.html
http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
