CREATE VIEW view_name AS SELECT column_name1,column_name2,……FROM table_name WHERE condition;
CREATE OR REPLACE view_name AS SELECT cloumn_name1,column_name2,……FROM table_name WHERE condition;
DROP VIEW view_name;
原文：https://www.cnblogs.com/yaoze2018/p/11006452.html