GNU Info

(mysql.info)Missing Views

---

Next: Missing comments Prev: Broken Foreign KEY Up: Missing functions

---

Enter node , (file) or (file)node

Views
.....

MySQL doesn't yet support views, but we plan to implement these to
about 4.1.

Views are mostly useful for letting users access a set of relations as
one table (in read-only mode).  Many SQL databases don't allow one to
update any rows in a view, but you have to do the updates in the
separate tables.

As MySQL is mostly used in applications and on web system where the
application writer has full control on the database usage, most of our
users haven't regarded views to be very important. (At least no one has
been interested enough in this to be prepared to finance the
implementation of views).

One doesn't need views in MySQL to restrict access to columns as MySQL
has a very sophisticated privilege system. Note: Privilege system.