MySQL views

The basic syntax to create a view is as follows;

CREATE VIEW view_name

AS

SELECT something, somethingElse

FROM someTable;

A view doesn't need to be triggered to force an update, as soon as the view is queried, it will populate with current data.

We could in theory, query our above example with;

SELECT * 

FROM

new_name;

A view is different from a stored procedure in that a view is simply a view of some data, possibly only selecting some data from a table or tables whereas a stored procedure can be more complex and actually do things such as inserting, deleting etc.

An example of a stored procedure is as below;

DELIMITER //

CREATE PROCEDURE GetMyStuff()

BEGIN SELECT * 

FROM products; 

END // 

DELIMITER ;

 

We can call the procedure as below;

CALL GetMyStuff();

 

See also https://blog.david14.com/2020/06/stored-procedures-in-mysql-and-postgrsql.html