[MariaDB] 뷰

1) 특정 데이터베이스의 뷰 조회

SHOW FULL TABLES;

 

2) 뷰 생성

CREATE VIEW view_name AS SELECT * FROM table_name WHERE 조건;

※ 생성 후 참조 테이블의 구조가 변경(DDL 명령어)될 경우 뷰를 재정의 해야합니다.

 

ex)

CREATE VIEW red_team AS SELECT * FROM user_info WHERE team_id = 1;

CREATE VIEW blue_team AS SELECT * FROM user_info WHERE team_id = 2;

CREATE VIEW yellow_team AS SELECT * FROM user_info WHERE team_id = 3;

CREATE VIEW green_team AS SELECT * FROM user_info WHERE team_id = 4;

 

3) 뷰 이름 변경

RENAME TABLE old_name TO new_name;

ex) RENAME TABLE red_team TO orange_team;

 

4) 뷰 수정

ALTER VIEW view_name AS SELECT * FROM table_name WHERE 조건;

ex)  ALTER VIEW blue_team AS SELECT name,email FROM user_info WHERE team_id=2;

 

5) 삭제

DROP VIEW view_name;