Recently upgraded to MariaDB 10.3 which has a new feature whereby we can create an invisible column like so:


But once I create this column, MySql Workbench will error on this table. Is there any way to workaround this? Or is there another GUI tool that can deal with this new column type?

  • List on their kb no idea which ones keep up with later features sorry.
    – danblack
    Feb 27, 2019 at 4:08
  • Yes, and there is also a link to a list of tools that support MariaDB enhanced features (mariadb.com/kb/en/library/applications-supporting-mariadb). I've tried mysql maestro, and at least it doesn't error, but it also doesn't see its Invisible attribute.
    – ChrisF
    Feb 27, 2019 at 4:17
  • "error on this table" -- Please explain and show the message.
    – Rick James
    Mar 7, 2019 at 4:19
  • When I use the table structure tool on a table which contains an Invisible column, MysqlWorkbench generates the following message: Error Parsing DDL for tablename Then there is an option to view the DDL, which shows the full table CREATE statement with a red X marking the statement defining the Invisible colum
    – ChrisF
    Mar 7, 2019 at 4:30

1 Answer 1


MySQL Workbench currently supports MySQL version 5.6, 5.7 and 8.0 and has support for MySQL invisible columns indexes, (recursive) CTEs, JSON and all other (for a GUI relevant) features added to MySQL (like cached sha2 passwords).

  • MySQL invisible columns? I've heard of MariaDB invisible columns, but MySQL?
    – dbdemon
    Feb 27, 2019 at 9:08
  • Oh, my fault, I confused columns with indexes. Feb 27, 2019 at 12:22
  • As of MySQL 8.0.23, invisible columns are a feature. They work fine from MySQL Workbench too.
    – prasad_
    Dec 30, 2023 at 6:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.