Updating views in mysql

The database system stores views as a SQL SELECT statement with joins.When the data of the tables changes, the view reflects that changes as well.Most database management systems, including My SQL, allow you to update data in the underlying tables through the database view with some prerequisites.A database view is dynamic because it is not related to the physical schema.(Note that even if a view is updatable, it might not be possible to insert into it, as described elsewhere in this section.) The updatability of views may be affected by the value of the system variable. Earlier discussion in this section pointed out that a view is not insertable if not all columns are simple column references (for example, if it contains columns that are expressions or composite expressions).Although such a view is not insertable, it can be updatable if you update only columns that are not expressions.Mukesh Chapagain is a graduate of Kathmandu University (Dhulikhel, Nepal) from where he holds a Masters degree in Computer Engineering.Mukesh is a passionate web developer who has keen interest in open source technologies, programming & blogging.

For a view to be updatable, there must be a one-to-one relationship between the rows in the view and the rows in the underlying table.

There are also certain other constructs that make a view nonupdatable.

To be more specific, a view is not updatable if it contains any of the following: are illegal and are rejected.

A database view is a virtual table or logical table which is defined as a SQL SELECT query with joins.

Because a database view is similar to a database table, which consists of rows and columns, so you can query data against it.

Search for updating views in mysql:

updating views in mysql-78updating views in mysql-73

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating views in mysql”