脚踏实地、勇往直前!
全部博文(1005)
分类: Mysql/postgreSQL
2014-08-27 14:31:29
[mysql@node2 hxl]$ ls -1 tb_enum_test*.frm
tb_enum_test.frm
tb_enum_test_new.frm
[mysql@node2 hxl]$ mv tb_enum_test.frm tb_enum_test_tmp.frm
[mysql@node2 hxl]$ mv tb_enum_test_new.frm tb_enum_test.frm
[mysql@node2 hxl]$ mv tb_enum_test_tmp.frm tb_enum_test_new.frm
6.解锁
mysql>unlock tables;
7.查看原来表的enum值,看是否生效
mysql> show columns from tb_enum_test like 'e';
+-------+----------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+----------------------------------+------+-----+---------+-------+
| e | enum('fish','apple','dog','pig') | YES | | pig | |
+-------+----------------------------------+------+-----+---------+-------+
1 row in set (0.01 sec)
可以看出已经生效,整个过程是很快的.
-- The End --