Performs the insert (...) values action.
This method is similar to InsertQueryBuilder.values, so see the documentation for that method for more examples.
To perform the do nothing action, see thenDoNothing.
const result = await db.mergeInto('person')
.using('pet', 'person.id', 'pet.owner_id')
.whenNotMatched()
.thenInsertValues({
first_name: 'John',
last_name: 'Doe',
})
.execute()
The generated SQL (PostgreSQL):
merge into "person"
using "pet" on "person"."id" = "pet"."owner_id"
when not matched then
insert ("first_name", "last_name") values ($1, $2)
Performs the insert (...) values action.
This method is similar to InsertQueryBuilder.values, so see the documentation for that method for more examples.
To perform the do nothing action, see thenDoNothing.
const result = await db.mergeInto('person')
.using('pet', 'person.id', 'pet.owner_id')
.whenNotMatched()
.thenInsertValues({
first_name: 'John',
last_name: 'Doe',
})
.execute()
The generated SQL (PostgreSQL):
merge into "person"
using "pet" on "person"."id" = "pet"."owner_id"
when not matched then
insert ("first_name", "last_name") values ($1, $2)
Performs the
do nothingaction.This is supported in PostgreSQL.
To perform the
insertaction, see thenInsertValues.Examples
The generated SQL (PostgreSQL):