MySQL JSON Replace
mysql_json_replaceUpdate JSON column values by replacing only when the specified JSON path exists, ensuring no unintended inserts.
Instructions
Replace values in JSON columns only if the path exists.
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 replace | |
| 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 | Replacement 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 |