View

생성

--기본
CREATE VIEW schema_name.view_name AS SELECT column_name1, column_name2 ... FROM schema_name.table_name;

--컬럼끼리 계산
CREATE VIEW schema_name.view_name AS
SELECT column_name1, SUM(column_name2 * column_name3) AS alias_name
FROM schema_name.table_name
GROUP BY column_name1;

갱신

--뷰는 일부분만 갱신을 할 수 없으므로 전체를 갱신해야함
CREATE OR REPLACE VIEW schema_name.view_name AS SELECT column_name1, column_name2 ... FROM schema_name.table_name;

DDL 확인

SHOW CREATE VIEW view_name;