Skip to main content
Go to Latest
method PreparedQuery.prototype.execute
import { PreparedQuery } from "https://deno.land/x/sqlite@v3.7.2/mod.ts";

Binds the given parameters to the query and executes the query, ignoring any rows which might be returned.

Using this method is more efficient when the rows returned by a query are not needed or the query does not return any rows.

Examples

const query = db.prepareQuery<never, never, [string]>("INSERT INTO people (name) VALUES (?)");
query.execute(["Peter"]);
const query = db.prepareQuery<never, never, { name: string }>("INSERT INTO people (name) VALUES (:name)");
query.execute({ name: "Peter" });

See QueryParameterSet for documentation on how values can be bound to SQL statements.

See QueryParameter for documentation on how values are returned from the database.

Parameters

optional
params: P