At 06:04 PM 23/04/2002 -0700, you wrote:
>http://www.google.com/search?hl=en&q=Views+Mysql > ... > > MySQL Manual | 1.7.4.6 Views > ... It is planned to implement views in MySQL Server around Version >4.1. Views are mostly > useful for letting users access a set of relations as one table (in >read ... > www.mysql.com/doc/A/N/ANSI_diff_Views.html - 17k - Cached - Similar >pages > > MySQL Manual | 1.7.3.7 Views > ... One doesn't need views in MySQL to restrict access to >columns as MySQL has a very > sophisticated privilege system. See section 4.2 General >Security Issues and ... > www.mysql.com/doc/M/i/Missing_Views.html - 9k - Cached - >Similar pages > [ More results from www.mysql.com ] Views made it possible to implement one of the most ambitious projects at a company I worked for. The project involved a new methodology that I stole - er - developed. It used a modular data model that let us model the entire corporation in under a year when the original estimate was in excess of 5 years. We were able to bring SECTIONS of the system to production a blinding speed. As an example, we brought one section up and running a full year before we were scheduled to start. It seems that one of the programmers had a free weekend and did it all - instead of taking 3 programmers a year. None of it would have been possible if we had not had views (Oracle on the mainframe and on PCs) to isolate the inner complexity from the application. I'd love to try such a project with MySQL. Here's hoping that 4.1 isn't too far off. >-----Original Message----- >From: Arthur Fuller [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, April 23, 2002 5:57 PM >To: Jonathan Hilgeman; [EMAIL PROTECTED] >Subject: Re: I thought MySQL Supported Relationships > > >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 > >--------------------------------------------------------------------- >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
