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

Question

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

Answer 1

Are you sure you have the latest version of MySQL Workbench. I don't see this problem in the current one (6.3.6):

Answer 2

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')