更改视图相当于重新定义一个已经存在的视图。 <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] ```