Movatterモバイル変換

ALTER    [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]    [DEFINER =user]    [SQL SECURITY { DEFINER | INVOKER }]    JSON DUALITY VIEWview_name    ASjson_duality_select_statement    [WITH [CASCADED | LOCAL] CHECK OPTON]json_duality_select_statement:     SELECTjson_duality_object_expression    FROM [schema_name .]root_table_name [AStable_alias_name]

This statement updates a JSON duality view.

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

For more information, seeSection 27.7, “JSON Duality Views”.

This statement was added in MySQL 9.4.0.