Page 1 of 1

Feature Request: Add support for INVISIBLE columns as introduced in MySQL 8.0.23+

Posted: Mon 07 Mar 2022 11:06
by tfrancois
As of MySQL 8 version 8.0.23, support for INVISIBLE columns has been added and I am able to create a table with the INVISIBLE flag as shown:

Code: Select all

CREATE TABLE t1 (
  i INT,
  j DATE INVISIBLE
) ENGINE = InnoDB;

ALTER TABLE t1 ADD COLUMN k INT INVISIBLE;
See documentation on this feature:
https://dev.mysql.com/doc/refman/8.0/en ... lumns.html

The issue is that the visibility status of the column is now shown/displayed in the Table Editor in dbForge or in the accompanying Create Table SQL tab there either. Can the visibility status be shown in the Column properties and create table SQL code for MySQL versions that support this?

Thank you!

Re: Feature Request: Add support for INVISIBLE columns as introduced in MySQL 8.0.23+

Posted: Tue 15 Mar 2022 13:57
by Raudar
Hi there,

Please note that we are already working on this and will add this functionality in one of the further releases.

Cheers,
Devart Team