DB.prototype.execute - db documentation

method DB.prototype.execute



DB.prototype.execute(sql: string,
params?: unknown[],
): Task<number, QueryFailed | ConstraintViolation>

Execute INSERT/UPDATE/DELETE and return affected row count.

Examples

const affected = await db.execute("DELETE FROM users WHERE id = ?", [1]).run();



sql: string

optional



params: unknown[]

Task<number, QueryFailed | ConstraintViolation>