Sample Header Ad - 728x90

How to use MariaDB's new "Invisible" column type

0 votes
1 answer
201 views
I have been playing around with this new column type. The use case being that I want to hide this column from a client issuing a "Select *" query. But the column seems to behave like any normal column and is not hidden. I have enabled the Invisible column type by using the following command: ALTER TABLE MyTable ADD COLUMN TestA INT INVISIBLE; Reading up in the MariaDB documentation , the examples provided are only with Create statements. Which makes me wonder if one can only enable this feature when creating a table and NOT with an Alter statement. Can anybody shed some light?
Asked by ChrisF (21 rep)
Feb 28, 2019, 01:13 AM
Last activity: Jun 23, 2025, 11:38 AM