onDuplicateKeyUpdate() — drizzle-orm Function Reference

Architecture documentation for the onDuplicateKeyUpdate() function in insert.ts from the drizzle-orm codebase.

Function typescript DrizzleORM QueryBuilders

Entity Profile

DrizzleORM→ QueryBuilders→ onDuplicateKeyUpdate() — drizzle-orm Function Reference

Dependency Diagram

graph TD
  3cbaac64_3373_43fa_7259_13ef251e2421["onDuplicateKeyUpdate()"]
  d9829954_9fca_878f_0f03_c2600b4170e4["MySqlInsertBase"]
  3cbaac64_3373_43fa_7259_13ef251e2421 -->|defined in| d9829954_9fca_878f_0f03_c2600b4170e4
  style 3cbaac64_3373_43fa_7259_13ef251e2421 fill:#6366f1,stroke:#818cf8,color:#fff

Relationship Graph

Source Code

drizzle-orm/src/mysql-core/query-builders/insert.ts lines 273–279

	onDuplicateKeyUpdate(
		config: MySqlInsertOnDuplicateKeyUpdateConfig<this>,
	): MySqlInsertWithout<this, TDynamic, 'onDuplicateKeyUpdate'> {
		const setSql = this.dialect.buildUpdateSet(this.config.table, mapUpdateSet(this.config.table, config.set));
		this.config.onConflict = sql`update ${setSql}`;
		return this as any;
	}