How to use MariaDB's new "Invisible" column type
The INVISIBLE is an attribute of the column it can be set CREATE TABLE and ALTER TABLE statements.

I've updated the reference page document to show this.

 CREATE TABLE t (x INT, y INT INVISIBLE, z INT INVISIBLE NOT NULL DEFAULT 4);

 DESC t;



Field | Type    | Null | Key | Default | Extra    
:---- | :------ | :--- | :-- | :------ | :--------
x     | int(11) | YES  |     | null    |          
y     | int(11) | YES  |     | null    | INVISIBLE
z     | int(11) | NO   |     | 4       | INVISIBLE


ALTER TABLE t MODIFY x INT INVISIBLE, MODIFY y INT, MODIFY z INT NOT NULL DEFAULT 4

DESC t



Field | Type    | Null | Key | Default | Extra    
:---- | :------ | :--- | :-- | :------ | :--------
x     | int(11) | YES  |     | null    | INVISIBLE
y     | int(11) | YES  |     | null    |          
z     | int(11) | NO   |     | 4       |          


db&lt;>fiddle here