Re: Relation Among Tables Urgent()
l, > > I want to create an one to one relationship among > tables using SQL. How can i do this. I creates an > relation but it dose not expect my needs. For Ex they > are two table say tbset nad tb tbprocess. If i set an > one to one relation between the two tables in which > the master table is tbset. If i change the values in > the tbset table the change should be refleted in the > slave table that is tbprocess. I think i can do this > in msacess. But i changed to mysql in which i need to > write the Query(There is no gui for mysql as like > msacess). Pls Reply me regarding this > > Balaji > > __ > Give your Company an email address like > ravi @ ravi-exports.com. Sign up for Rediffmail Pro today! > Know more. http://www.rediffmailpro.com/signup/ > > - > 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 -- We are not the United States' ally We are the 53rd sovereign state mysql,query I think you're asking for foreign key updates, which aren't currently supported in MyISAM tables. DSL - 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: Relation Among Tables Urgent()
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
Relation Among Tables Urgent()
Hi all, hi all, I want to create an one to one relationship among tables using SQL. How can i do this. I creates an relation but it dose not expect my needs. For Ex they are two table say tbset nad tb tbprocess. If i set an one to one relation between the two tables in which the master table is tbset. If i change the values in the tbset table the change should be refleted in the slave table that is tbprocess. I think i can do this in msacess. But i changed to mysql in which i need to write the Query(There is no gui for mysql as like msacess). Pls Reply me regarding this Balaji __ Give your Company an email address like ravi @ ravi-exports.com. Sign up for Rediffmail Pro today! Know more. http://www.rediffmailpro.com/signup/ - 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