Database updating view

I tried:create view v1 as select * from t1 JOIN (select * from t2 where ...) USING (id) where ..which gave me the "subquery in FROM clause" error.Solution/work around:create view v2 as select * from t2 where ...;create view v1 as select * from t1 JOIN v2 USING (id) where ...(example above is an overly simplified version of what I did for demonstration puposes).

database updating view-22

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.

The key is the from the document’s The bulk document API allows you to create and update multiple documents at the same time within a single request.

The basic operation is similar to creating or updating a single document, except that you batch the document structure and information.

When a view is referenced, privilege checking occurs as described later in this section. By default, a new view is created in the default database.

Last modified 22-Apr-2017 13:37