Perhaps I fail to catch the humour in your response, or the flavour of this newsgroup, but I find your answer in no way helpful, and beyond that quite insulting to Access.
1. I have developed applications in Access comprising over 1000 tables, some of which contain millions of rows, with numerous complex relationships and C++ components that interfaced to instruments such as scales, scanners, etc. I am not the only one to push Access that far. 2. To answer Andrew's question, the answer is No. MySQL does not support defined relationships. The InnoDB extension provides this support. 3. Unfortunately, as of this writing neither MySQL nor InnoDB supports defined queries (Oracle and SQL Server call them Views). Allegedly, MySQL 4.1 will support stored procedures (and I for one hope that views make it into the build). Arthur ----- Original Message ----- From: "Jonathan Hilgeman" <[EMAIL PROTECTED]> To: "'Andrew Kuebler'" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 2:43 PM Subject: RE: I thought MySQL Supported Relationships > Actually, no. The addiction to MySQL has caused many relationship break-ups. > There's probably even a database with that information out there somewhere. > Probably a MySQL database, too. Meanwhile Access supports relationships > because it blows so hard that people can't wait to get away from it and home > to their families. > > - Jonathan > > -----Original Message----- > From: Andrew Kuebler [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 23, 2002 11:35 AM > To: [EMAIL PROTECTED] > Subject: I thought MySQL Supported Relationships > > > Hello Everyone. > > I'm still fairly a newbie to MySQL, but I could have sworn I read > somewhere that MySQL supported relationships just like Access. I've > searched the entire manual, and cannot find anything on the subject. > Does MySQL support relationships, and if so does anyone know where I can > find any info on the topic? Thanks! > > Andrew > > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
