Hi Monty!
I had a situation a while ago where i needed to use a view of a table.
Since MySQL doesn't support views I tried to find an alternative
mechanism to do the same thing and i found it, more or less. Since the
tables are file based I just created a symbolic link to the table and
thus created a second table that's always in sync with the original. As
far as I can see, this wouldn't need all too much of a programming
effort to achieve via create view from inside MySQL. Is this something
you could consider implementing in upcoming versions?
I now, views are just barely necessary, but they do make some things
easier for the programmers and if including it in the syntax doesn't
mean a lot of work, well...
/Ed
--
###### ====== ------ Eddie Olsson ------======######
###### A computer without MS Windows is like a fish without a bicycle ######
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.