ALTER
    [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    [DEFINER = user]
    [SQL SECURITY { DEFINER | INVOKER }]
    VIEW view_name [(column_list)]
    AS select_statement
    [WITH [CASCADED | LOCAL] CHECK OPTION]

This statement changes the definition of a view, which must exist. 此语句更改视图的定义，视图必须存在。The syntax is similar to that for CREATE VIEW see Section 13.1.23, “CREATE VIEW Statement”). 语法与CREATE INDEX的语法类似，请参阅第13.1.23节，“CREATE INDEX语句”。This statement requires the CREATE VIEW and DROP privileges for the view, and some privilege for each column referred to in the SELECT statement. 此语句需要视图的CREATE VIEW和DROP权限，以及SELECT语句中引用的每个列的一些权限。ALTER VIEW is permitted only to the definer or users with the SET_USER_ID privilege (or the deprecated SUPER privilege).ALTER VIEW仅允许定义者或具有SET_USER_ID权限（或不推荐使用的SUPER权限）的用户使用。