Description:
Once open the table from Workbench, table column will missing
How to repeat:
mysql> create database demo;
Query OK, 1 row affected (0.00 sec)
mysql> use demo;
Database changed
mysql> CREATE TABLE `test_table` (
-> `id` int(11) NOT NULL AUTO_INCREMENT,
-> `name` varchar(64) DEFAULT NULL,
-> `createtime` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6),
-> `updatetime` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
-> `add` varchar(45) DEFAULT NULL,
-> PRIMARY KEY (`id`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Query OK, 0 rows affected (0.04 sec)
mysql> show tables;
+----------------+
| Tables_in_demo |
+----------------+
| test_table |
+----------------+
1 row in set (0.00 sec)
mysql> desc test_table;
+------------+--------------+------+-----+----------------------+--------------------------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+----------------------+--------------------------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(64) | YES | | NULL | |
| createtime | timestamp(6) | YES | | CURRENT_TIMESTAMP(6) | |
| updatetime | timestamp(6) | YES | | CURRENT_TIMESTAMP(6) | on update CURRENT_TIMESTAMP(6) |
| add | varchar(45) | YES | | NULL | |
+------------+--------------+------+-----+----------------------+--------------------------------+
5 rows in set (0.01 sec)
then open mysql Workbench 6.4, connect to the database demo, chose the table test_table, right click table name and chose [alter table], on the workbench GUI, the column `add` not display there, and index also not showing.
Description: Once open the table from Workbench, table column will missing How to repeat: mysql> create database demo; Query OK, 1 row affected (0.00 sec) mysql> use demo; Database changed mysql> CREATE TABLE `test_table` ( -> `id` int(11) NOT NULL AUTO_INCREMENT, -> `name` varchar(64) DEFAULT NULL, -> `createtime` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6), -> `updatetime` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6), -> `add` varchar(45) DEFAULT NULL, -> PRIMARY KEY (`id`) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; Query OK, 0 rows affected (0.04 sec) mysql> show tables; +----------------+ | Tables_in_demo | +----------------+ | test_table | +----------------+ 1 row in set (0.00 sec) mysql> desc test_table; +------------+--------------+------+-----+----------------------+--------------------------------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+----------------------+--------------------------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(64) | YES | | NULL | | | createtime | timestamp(6) | YES | | CURRENT_TIMESTAMP(6) | | | updatetime | timestamp(6) | YES | | CURRENT_TIMESTAMP(6) | on update CURRENT_TIMESTAMP(6) | | add | varchar(45) | YES | | NULL | | +------------+--------------+------+-----+----------------------+--------------------------------+ 5 rows in set (0.01 sec) then open mysql Workbench 6.4, connect to the database demo, chose the table test_table, right click table name and chose [alter table], on the workbench GUI, the column `add` not display there, and index also not showing.