|
|
 |
 Business Letters Personal Letters Resumes CVs and more |
|
|
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;
|
|
|
