15.1.6 ALTER JSON DUALITY VIEW Statement

ALTER
    [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    [DEFINER = user]
    [SQL SECURITY { DEFINER | INVOKER }]
    JSON DUALITY VIEW view_name
    AS json_duality_select_statement
    [WITH [CASCADED | LOCAL] CHECK OPTON]

json_duality_select_statement: 
    SELECT json_duality_object_expression
    FROM [schema_name .] root_table_name [AS table_alias_name]

This statement updates a JSON duality view.

json_duality_select_statement follows the same rules as for CREATE JSON DUALITY VIEW. json_duality_object_expression is a value returned by JSON_DUALITY_OBJECT(). See the description of that function for information about its arguments.

For more information, see Section 27.7, “JSON Duality Views”.

This statement was added in MySQL 9.4.0.