execute
Execute INSERT or UPDATE statements on a local MySQL database to modify data. Use parameterized queries with placeholders for secure database operations in development environments.
Instructions
Run a single INSERT or UPDATE statement against the local FO MySQL database. DELETE, DDL (CREATE/ALTER/DROP/TRUNCATE), and all other statement types are rejected. Use the schema parameter or fully-qualified table names. Use ? placeholders and pass values via the params array. Returns affectedRows and insertId.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | A single INSERT or UPDATE statement using ? placeholders. | |
| params | No | Positional parameters bound to ? placeholders. | |
| schema | No | Optional default schema for unqualified table names. |