update_records
Update MySQL table rows by applying set values to records that match required AND-combined where conditions, enabling targeted data changes without full table writes.
Instructions
Actualiza registros que cumplan where (obligatorio y no vacío).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table": "<table>",
"set": "<set>",
"where": "<where>"
},
"name": "update_records"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| set | Yes | ||
| table | Yes | ||
| where | Yes | Condiciones unidas por AND. {"id": 5} => id = 5; {"estado": ["a","b"]} => IN; {"borrado": null} => IS NULL | |
| database | No | Base de datos a usar (por defecto la actual de la conexión activa) |