MySQL Create view

MySQL Create view

To create a MySQL view uses keyword create o replace view syntax.

MySQL Create view syntax

CREATE OR REPLACE VIEW view_name AS SELECT * FROM tabel_name;

Create view example

CREATE OR REPLACE VIEW test_view 
AS 
SELECT * FROM test;

Output

view TEST_VIEW created.