Aikesheng Open Source Community

Jan 12, 2021 · Databases

How to Quickly Find Missing Auto‑Increment Primary Key Values in MySQL

This article explains several efficient methods—including shell scripts, generated series tables, JSON functions, and MySQL 8.0 recursive CTEs—to quickly locate missing auto‑increment primary key values in a MySQL table, comparing their performance and suitability.