Mastering MySQL Duplicate Key Update with Custom MyBatis‑Plus Injector

Learn how to efficiently handle upserts in MySQL by leveraging the native DUPLICATE KEY UPDATE feature, simplifying code with a custom MyBatis‑Plus AbstractMethod injector, complete with thread‑safe locking, SQL generation, and integration steps for seamless backend development.

Duplicate Key Updatebackend-developmentjava

0 likes · 9 min read

Mastering MySQL Duplicate Key Update with Custom MyBatis‑Plus Injector

Aikesheng Open Source Community

Nov 6, 2024 · Databases

Understanding INSERT … ON DUPLICATE KEY UPDATE Locking in MySQL InnoDB (Repeatable‑Read vs Read‑Committed)

This article explains how MySQL 8.0.32 InnoDB handles INSERT … ON DUPLICATE KEY UPDATE under REPEATABLE‑READ and READ‑COMMITTED isolation levels, showing the preparation steps, lock acquisition process, and why the same exclusive record lock is obtained in both cases.

Duplicate Key UpdateInnoDBmysql

0 likes · 7 min read

Understanding INSERT … ON DUPLICATE KEY UPDATE Locking in MySQL InnoDB (Repeatable‑Read vs Read‑Committed)