CREATE VIEW

The optional clause causes the view to be replaced if it already exists rather than raising an error.

In the INVOKER security mode, tables referenced in the view are accessed using the permissions of the query user (the invoker of the view). A view created in this mode is simply a stored query.

Create a view that summarizes orders:

DROP VIEW,