Interface InsertOptions

Options for building an INSERT, including returning clauses and conflict handling where the engine supports them.

interface InsertOptions {
    schema?: string;
    returning?: boolean | string[];
    upsert?: boolean;
    conflictFields?: string[];
    updateOnDuplicate?: string[];
}

Properties

schema?: string

Schema to use for the table

returning?: boolean | string[]

upsert?: boolean

conflictFields?: string[]

updateOnDuplicate?: string[]

Fields to update on conflict (MySQL: ON DUPLICATE KEY UPDATE, PostgreSQL/SQLite: ON CONFLICT DO UPDATE, MariaDB: ON DUPLICATE KEY UPDATE)