ITPUB

Oct 8, 2023 · Databases

Unlocking MySQL GIPKs: How Generated Invisible Primary Keys Simplify Schema Design

Starting with MySQL 8.0.30, the Generated Invisible Primary Keys (GIPKs) feature automatically adds an invisible bigint auto‑increment column named my_row_id when a table lacks an explicit primary key, simplifying schema design, easing DBA‑developer conflicts, and offering flexible handling in MGR and replication environments, while noting its limitations and usage commands.