Execute Write SQL
mysql_executeDestructive
Execute write SQL statements such as INSERT, UPDATE, DELETE, and DDL on a MySQL database, with optional bind parameters and database selection.
Instructions
Execute a write SQL statement (INSERT, UPDATE, DELETE, DDL).
WARNING: This tool modifies data. Use with caution.
Args:
sql (string, required): SQL statement. Use ? placeholders for parameters.
params (array, optional): Bind parameters corresponding to ? placeholders.
database (string, optional): Database name. Uses MYSQL_DATABASE if omitted.
Returns: { affectedRows: number, insertId: number, changedRows: number }
Examples:
sql: "UPDATE biz_exhaust_hy SET DELETE_FLAG = 'DELETED' WHERE ID = ?", params: [123]
sql: "INSERT INTO my_table (name) VALUES (?)", params: ["test"]
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | Write SQL statement. Use ? for bind parameters. | |
| params | No | Bind parameters for ? placeholders | |
| database | No | Database name (uses MYSQL_DATABASE env var if omitted) |