How do I append more elements to an ENUM-type in MySQL Workbench?

user_3549132 0
Viewed 6542

As the title suggests, i'm trying to add more elements to my existing ENUM-type column. I'm using MySQL Workbench 6.3 for my database.

CREATE TABLE `quantum` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` enum('a','b','c','d','e') CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11173 DEFAULT CHARSET=utf8;

then I try to alter type column to add another element f

ALTER TABLE quantum
MODIFY COLUMN type enum('a','b','c','d','e','f') NOT NULL

then MySQL Workbench 6.3 is giving me some weird error

enter image description here

mysql-workbench enums mysql
2 Answers

While using enum() datatype in workbench/ mysql. Mysql do not aceept ENUM() with no values/params inside the ENUM().

Use ENUM with some comma separated values :

ENUM('PENDING','SUCCESS','FAIL')

enter image description here

user_34251520
Related