This is the first post dedicated to this new feature, I expect to write a series of 3. This one is the introduction.
Prior to MySQL 8.0.23, all columns of a table were always visible (if you had the privilege to see it). Now, an invisible column can be specified and will be hidden to queries. It can always be accessed if explicitly referenced.
Let’s see how it works:
create table table1 ( id int auto_increment primary key, name varchar(20), age int invisible);
In the table description we can see the
keyword in the Extra column:
desc table1; …[Read more]