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 ]
...
C:~
-----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
