How To Create a New View in MySQL? | MySQL Interview Questions

You can create a new view based on one or more existing tables by using the “CREATE VIEW viewName AS selectStatement” statement as shown in the following script:
mysqi> CREATE TABLE comment (faqiD INTEGER,
message VARCHAR(256));
Query OK, 0 rows affected (0.45 see)
mysqi> INSERT INTO comment VALUES (1, ‘1 like it’);
Query OK, 1 row affected (0.00 see)
mysqi> CREATE VIEW faqCornrnent AS SELECT f.id. f.title,
f.description, c.rnessage FROM faq 1., comment c
WHERE f.id = c.faqlD;
Query OK, 0 rows affected (0.06 see)
mysqi> SELECT * FROM faqCorr.ment;