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
