{"body":"mysql> create table t (nonenum varchar(255), anenum ENUM('x', 'y'));\nQuery OK, 0 rows affected (0.07 sec)\n\nmysql> insert into t (nonenum, anenum) values ('Thing', 'x');\nQuery OK, 1 row affected (0.04 sec)\n\nmysql> insert into t (nonenum, anenum) values ('Thing', 'x');\nQuery OK, 1 row affected (0.00 sec)\n\nmysql> insert into t (nonenum, anenum) values ('Thing', 'y');\nQuery OK, 1 row affected (0.01 sec)\n\nmysql> insert into t (nonenum, anenum) values ('Thing', 'y');\nQuery OK, 1 row affected (0.00 sec)\n\nmysql> select * from t;\n+---------+--------+\n| nonenum | anenum |\n+---------+--------+\n| Thing   | x      |\n| Thing   | x      |\n| Thing   | y      |\n| Thing   | y      |\n+---------+--------+\n4 rows in set (0.00 sec)\n\nmysql> show create table t\n    -> ;\n+-------+----------------------------------------------------------------------------------------------------------------------------------------+\n| Table | Create Table                                                                                                                           |\n+-------+----------------------------------------------------------------------------------------------------------------------------------------+\n| t     | CREATE TABLE `t` (\n  `nonenum` varchar(255) DEFAULT NULL,\n  `anenum` enum('x','y') DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=latin1 |\n+-------+----------------------------------------------------------------------------------------------------------------------------------------+\n1 row in set (0.00 sec)\n\nmysql> alter table t modify anenum varchar(255);\nQuery OK, 4 rows affected (0.15 sec)\nRecords: 4  Duplicates: 0  Warnings: 0\n\nmysql> select * from t\n    -> ;\n+---------+--------+\n| nonenum | anenum |\n+---------+--------+\n| Thing   | x      |\n| Thing   | x      |\n| Thing   | y      |\n| Thing   | y      |\n+---------+--------+\n4 rows in set (0.00 sec)\n\nmysql> show create table t;\n+-------+---------------------------------------------------------------------------------------------------------------------------------------+\n| Table | Create Table                                                                                                                          |\n+-------+---------------------------------------------------------------------------------------------------------------------------------------+\n| t     | CREATE TABLE `t` (\n  `nonenum` varchar(255) DEFAULT NULL,\n  `anenum` varchar(255) DEFAULT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=latin1 |\n+-------+---------------------------------------------------------------------------------------------------------------------------------------+\n1 row in set (0.00 sec)\n\nmysql> \n","name":"","extension":"txt","url":"https://www.irccloud.com/pastebin/5Dn7SMAj","modified":1504898792,"id":"5Dn7SMAj","size":2660,"lines":66,"own_paste":false,"theme":"","date":1504898792}