Interface QueryResult<O>

interface QueryResult<O> {
    insertId?: bigint;
    numAffectedRows?: bigint;
    numChangedRows?: bigint;
    numUpdatedOrDeletedRows?: bigint;
    rows: O[];
}

Type Parameters

  • O

Properties

insertId? numAffectedRows? numChangedRows? numUpdatedOrDeletedRows? rows

Properties

Optional Readonly insertId

insertId?: bigint

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

Optional Readonly numAffectedRows

numAffectedRows?: bigint

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

Optional Readonly numChangedRows

numChangedRows?: bigint

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.

Optional Readonly numUpdatedOrDeletedRows

numUpdatedOrDeletedRows?: bigint

Deprecated

use QueryResult.numAffectedRows instead.

Readonly rows

rows: O[]

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

Settings

Member Visibility

Theme

On This Page

insertIdnumAffectedRowsnumChangedRowsnumUpdatedOrDeletedRowsrows