Aikesheng Open Source Community
Aug 7, 2023 · Databases
Understanding Invisible Columns, Generated Invisible Primary Keys, and Invisible Indexes in MySQL 8.0
This article explains three relatively new MySQL 8.0 features—hidden (invisible) columns, generated invisible primary keys, and invisible indexes—detailing their purpose, how to create and use them, and practical scenarios where they can help avoid schema‑change issues or test query performance.
Generated Primary KeyInvisible ColumnsInvisible Indexes
0 likes · 11 min read