QueryResult

interface QueryResult <O> {

readonly insertId?: bigint;

readonly numAffectedRows?: bigint;

readonly numChangedRows?: bigint;

readonly numUpdatedOrDeletedRows?: bigint;

readonly rows: O[];

}

§Type Parameters

[src]

§Properties

readonly insertId?: bigint

[src]

This is defined for insert queries on dialects that return the auto incrementing primary key from an insert.

readonly numAffectedRows?: bigint

[src]

This is defined for insert, update, delete and merge queries and contains the number of rows the query inserted/updated/deleted.

readonly numChangedRows?: bigint

[src]

This is defined for update queries and contains the number of rows the query changed. This is optional and only provided by some drivers like node-mysql2.

readonly numUpdatedOrDeletedRows?: bigint

[src]

readonly rows: O[]

[src]

The rows returned by the query. This is always defined and is empty if the query returned no rows.