NXT Remote Control | Pose HDTV | 265 PC Telecharger Far Cry 5 – PC Gratuit Far Cry 5 telecharger torrent Situé en Amérique pour la première fois, Far Cry...
 Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of create view syntax mysql

Popular Examples

More MYSQL Examples

See all MYSQL Examples
report this ad

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;