BestHub
search
Sign in
Tag

Invisible Columns

1 views collected around this technical thread.

Aikesheng Open Source Community
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
Understanding Invisible Columns, Generated Invisible Primary Keys, and Invisible Indexes in MySQL 8.0
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 11, 2021 · Databases

MySQL 8.0.23 Invisible Columns Feature Overview

Starting with MySQL 8.0.23, columns can be marked INVISIBLE, causing them to be omitted from SELECT * queries unless explicitly referenced; this article explains the feature, demonstrates creation, inspection, DML considerations, schema modifications, backup behavior, and its impact on database design.

Database DesignInvisible ColumnsPerformance
0 likes · 8 min read
MySQL 8.0.23 Invisible Columns Feature Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 19, 2021 · Databases

MySQL 8.0.23 New Features Overview

The article reviews MySQL 8.0.23's maintenance release, detailing new features such as invisible columns, query attributes, security enhancements, InnoDB auto‑extend size, replication terminology changes, X protocol improvements, and various deprecations, providing code examples and links to official documentation.

8.0.23InnoDBInvisible Columns
0 likes · 10 min read
MySQL 8.0.23 New Features Overview