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
Last activity: Jun 23, 2025, 11:38 AM