No MySQL does not currently support views because they are slower.
Basically when you select from a view it has to issue another query on the
original table making a view query slower than querying the original
table.
Mike Machado
mike@innercite.com
InnerCite
Network Specialist
On Wed, 14 Jul 1999, Brian Lavender wrote:
> Views are tables that are actually queries of other tables. They don't
> take up space on the database, but allow you to look at a window of
> another table. I frequently use them when I only want to view certain
> parent records stepping through each parent and seeing the associated
> child records for that parent.
>
> Does mySQL support views?
>
> brian
> --
> Brian Lavender
> Sacramento,CA
> Brie Business Directory - Napa Valley http://www.brie.com/bbd/
> (916) 628-0726
>
> "I hate to advocate drugs, alcohol, violence, or insanity to
> anyone, but they've always worked for me."
> -- Hunter S. Thompson
>
This archive was generated by hypermail 2b29 : Fri Feb 25 2000 - 14:29:06 PST