MySQL 9.4 Reference Manual Including MySQL NDB Cluster 9.4
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 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.