MySQL Views

[sde]

I was going through an SQL book and learned about 'views'. This is something that MySQL doesn't support yet, .. but apparently they plan to impliment it around version 6

1.8.4.6 Views

It is planned to implement views in MySQL Server around version 6.0.

Historically, MySQL Server has been most used in applications and on web systems where the application writer has full control over database usage. Of course, usage has shifted over time, and so we find that an increasing number of users now regard views as an important aspect.

Views are useful for allowing users to access a set of relations as if it were a single table, and limiting their access to just that. Many DBMS don't allow updates to a view, instead you have to perform the updates on the individual tables.

read more here: http://www.mysql.com/doc/en/ANSI_diff_Views.html

[Admin]

views are sweet dude.

i have been using them in oracle for quite some time. makes writting queries soooooooooooo much easier.