Re: How a VIEW is stored

2006-08-26 Thread Dan Nelson
In the last episode (Aug 26), Karl Larsen said: >I was working with my version 5 and made a couple of views which > are very useful. Looking in the db I was able to see the VIEW's saved > as TABLE :-) What command did you run to determine this? "SHOW TABLES" does list them but that's to be ex

How a VIEW is stored

2006-08-26 Thread Karl Larsen
I was working with my version 5 and made a couple of views which are very useful. Looking in the db I was able to see the VIEW's saved as TABLE :-) This was a surprise and not sure if this is the expected result or not. Then I did some SELECT that involved the VIEW and it does work a lo