dougongnan2167 2014-07-22 21:00
浏览 320
已采纳

MySql - 将字段枚举类型更改为tinyint时的奇怪行为

I'm updating all of my table fields with enum type to tinyint(1), but I'm seeing some strange behavior.

Say field_x type is enum('0','1','2');

After altering the table (ALTER TABLE a MODIFY field_x tinyint(1) NOT NULL DEFAULT 1), fields with original value 0 now have 1, fields with original value 1 now have 2...

Does anybody know what is causing this?

  • 写回答

1条回答 默认 最新

  • doumie6223 2014-07-22 21:09
    关注

    The underlying issue is the how enum is stored in mysql

    For enum('0','1','2') MySQL stores enum values internally as integer keys.

    So for above indexes are

    0 = 1
    1 = 2
    2 = 3
    

    So when you alter the colum to tinyint then the saved values which are as string being converted to the corresponding indexes for tinyint and you are getting

    1 for 0, 2 for 1 ....
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?