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).
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) |