Balaji,
Wednesday, August 14, 2002, 12:15:14 PM, you wrote:
BN> I want to create an one to one relationship among
BN> tables using SQL. How can i do this. I creates an
BN> relation but it dose not expect my needs. For Ex they
BN> are two table say tbset nad tb tbprocess. If i set an
BN> one to one relation between the two tables in which
BN> the master table is tbset. If i change the values in
BN> the tbset table the change should be refleted in the
BN> slave table that is tbprocess. I think i can do this
BN> in msacess.
For Referential Integrity you can use foreign keys (they are supported
by InnoDB table types). There is no ON UPDATE CASCADE in MySQL yet, but you can use ON
DELETE CASCADE and ON DELETE SET NULL since version 3.23.50
BN> But i changed to mysql in which i need to
BN> write the Query
Yes, you need to update table 'tbprocess' manually.
BN> (There is no gui for mysql as like
BN> msacess).
There are a lot of GUIs for MySQL. Some of them like MyCC and MySQLGUI you can find
here:
http://www.mysql.com/downloads/gui-clients.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [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
