有个字段是enum类型的,创建表的时候默认给了几个值
create tb_test(
id bigint,
filed_test enum('aa','bb') DEFAULT NULL;
)我现在想修改往enum里边增加一个值'cc',请问sql语句怎么写????alt tb_test modify filed_test enum('aa','bb','cc') DEFAULT NULL;
这样写报错,请大侠指点!
create tb_test(
id bigint,
filed_test enum('aa','bb') DEFAULT NULL;
)我现在想修改往enum里边增加一个值'cc',请问sql语句怎么写????alt tb_test modify filed_test enum('aa','bb','cc') DEFAULT NULL;
这样写报错,请大侠指点!
alter table tb_test modify filed_test enum('aa','bb','cc') DEFAULT NULL;
-> id bigint,
-> filed_test enum('aa','bb') DEFAULT NULL
-> );
Query OK, 0 rows affected (0.13 sec)mysql> alter table tb_test modify filed_test enum('aa','bb','cc') DEFAULT NULL;
Query OK, 0 rows affected (0.11 sec)
Records: 0 Duplicates: 0 Warnings: 0mysql> show create table tb_test;
+---------+---------------------------------------------------------------------
-----------------------------------------------------------------------------+
| Table | Create Table
|
+---------+---------------------------------------------------------------------
-----------------------------------------------------------------------------+
| tb_test | CREATE TABLE `tb_test` (
`id` bigint(20) DEFAULT NULL,
`filed_test` enum('aa','bb','cc') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+---------+---------------------------------------------------------------------
-----------------------------------------------------------------------------+
1 row in set (0.00 sec)mysql>