execute_dml
Execute a single INSERT, UPDATE, or DELETE statement in a transaction and commit. Returns rows affected; rolls back on error.
Instructions
Execute a single INSERT, UPDATE, or DELETE statement in a transaction and commit. database: key from list_databases. sql: one DML statement — do not include a trailing semicolon. Returns 'Done. Rows affected: N'. Throws and rolls back on error. Use execute_script to run multiple statements.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | ||
| sql | Yes |