ALTER  TABLE `tao_auth_rule` CHANGE `ismenu` `ishidden` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0目录1菜单,2按钮';

and I found all my customers (with '0' value) set to 1 when I'm waiting 0

Could you explain me, what's the trouble, please ?



Converting the ENUM to TINYINT might give unexpected results, as MySQL will actually already store your ENUM in the form of integers. To get the result you want, you should actually start by converting your column to a CHAR(1) and then go to TINYINT(1).