mysql enum tinyint_MySQL从枚举到tinyint问题

最新推荐文章于 2023-09-05 11:25:32 发布

陶斯琴

最新推荐文章于 2023-09-05 11:25:32 发布

阅读量140

点赞数

文章标签： mysql enum tinyint

本文链接：https://blog.csdn.net/weixin_35885813/article/details/113203253

版权

I've got a table with

`terms_of_payment` enum('0','1') NOT NULL DEFAULT '0' COMMENT ''

I run

ALTER TABLE `customer`

CHANGE `terms_of_payment` `terms_of_payment` TINYINT( 1 )

NOT NULL DEFAULT 0 COMMENT '';

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 ?

Bye

解决方案

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