Database Reference
In-Depth Information
Tip
Use Views for Retrieval As a rule, use views for data retrieval (
SELECT
statements)
and not for updates (
INSERT
,
UPDATE
, and
DELETE
).
Views are virtual tables. They do not contain data, but they contain queries that
retrieve data as needed, instead. Views provide a level of encapsulation around
MariaDB
SELECT
statements and can be used to simplify data manipulation, as
well as to reformat or secure underlying data.
