ktorm icon indicating copy to clipboard operation
ktorm copied to clipboard

Batch query or multiple onDuplicateKey at bulkInsertOrUpdate

Open Gerrist opened this issue 3 years ago • 1 comments

Hi,

Is it possible to have a bulkInsertOrUpdate query where each item has its own onDuplicateKey? I want to upsert multiple rows all with different primary keys.

Or is it possible to a batch of single insertOrUpdate queries so an upsert action doesn't take 10+seconds because each insertOrUpdate requires a new connection.

Thanks!

Gerrist avatar Oct 14 '22 12:10 Gerrist

Can you give an example for what you want to do?

vincentlauvlwj avatar Oct 14 '22 12:10 vincentlauvlwj