Example Of CREATE View Mysql Syntax:

CREATE
[OR REPLACE]
[ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
[DEFINER = { user | CURRENT_USER }]
[SQL SECURITY { DEFINER | INVOKER }]
VIEW view_name [(column_list)]
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION]

CREATE VIEW test.v AS SELECT * FROM t;

CREATE VIEW v AS SELECT * FROM t WHERE t.id = f(t.name);
IF name IS NULL THEN
CALL p1();
ELSE
CALL p2();
END IF;