MySQL Database

MySQL Views

Save a query as a reusable virtual table.

CREATE VIEW available_products AS
SELECT id, name, price
FROM products
WHERE stock > 0;

Query a view like a table. A normal view stores the query definition, not a separate copy of the result.