MySQL JSON Update
mysql_json_updateUpdate a JSON value in a MySQL table column by specifying the JSON path and a WHERE clause to identify the target row.
Instructions
Simple JSON value update by row ID.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| col | No | Alias for column | |
| sql | No | Alias for where | |
| val | No | Alias for value | |
| name | No | Alias for table | |
| path | No | JSON path to update | |
| query | No | Alias for where | |
| rowId | No | Alias for where (used with idColumn) | |
| table | No | Table name (Anti-Hallucination: Pass 'table', not 'tableName') | |
| value | No | New value | |
| where | No | WHERE clause to identify rows (REQUIRED. Anti-Hallucination: Pass 'where', not 'query' or 'sql') | |
| column | No | JSON column name | |
| filter | No | Alias for where | |
| idColumn | No | Alias for where (used with rowId) | |
| condition | No | Alias for where | |
| tableName | No | Alias for table | |
| columnName | No | Alias for column |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| code | No | Error code (e.g. VALIDATION_ERROR, QUERY_ERROR) | |
| data | No | ||
| error | No | Error message if operation failed | |
| details | No | Additional error context | |
| metrics | No | Token estimation metrics | |
| success | Yes | Whether the operation succeeded | |
| category | No | Error category (validation, query, connection, internal) | |
| suggestion | No | Suggested fix for the error | |
| recoverable | No | Whether the error is recoverable |