--- Derek Neighbors wrote: > Alex LeDonne said: > > If you want something that looks like a table for each day, you can > > create views. When I have to look at schema design, I now take as a > > general rule that anything resembling a "table with data in the > table > > name" should really be created as a view. > > Alex I agree with your assessment, but to my knowledge MySQL is still > a > very feature poor RDBMS and at this time still lacks an > implementation of > "views". I could be wrong, but that was the case last time I reviewed > its > feature sets. > > I agree with the recommendation to use views, but I think they are > not > available for MySQL users. :) > > -Derek Derek, you are correct, of course; as I mentioned, my MySQL is a bit rusty. So I suppose I should follow up by adding, "and if you really need views in a free RDBMS, look at PostgreSQL." -Alex __________________________________ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/