MySQL JSON Set
mysql_json_setUpdate values in JSON columns at specified paths by providing table, column, path, value, and WHERE clause.
Instructions
Set or update values in JSON columns at specified paths.
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 set | |
| 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 | Value to set | |
| 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 |