更改視圖相當于重新定義一個已經存在的視圖。 <br/> **1. 更改視圖的基本語法** ```sql # 語法1：不管視圖是否存在都重新定義視圖 # 就是創建視圖的語法啦 CREATE OR REPLACE VIEW view_name as select_statement ...; # 語法2：其實也是重新定義視圖 ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = {user | CURRENT_USER}] [SQL SECURITY {DEFINER | INVOKER}] VIEW view_name [(column_list}] AS select_statement [WITH [CASCADED | LOCAL | CHECK OPTION] ```