search

Home  >  Q&A  >  body text

mysql 数据库枚举类型enum,方便添加新的枚举项吗?

mysql数据库,中的ENUM数据类型,在创建表后续是否方便更新新的枚举项?
对enum接触的不多,如果在项目中用到是否方便,有没有什么例子?
有的原先的枚举类型,在数据库表中有用到,如果修改现有的枚举类型,会不会对数据库造成影响?

ringa_leeringa_lee2877 days ago717

reply all(1)I'll reply

  • 怪我咯

    怪我咯2017-04-17 11:15:08

    Tested:
    When the database table creation is completed, new enumeration data objects can be added, but the enumeration types used for the target data in the existing database cannot modify the enumeration items unless the current enumeration data items are not in used in the database. Other enumeration names can be modified if used in the data list of the enumeration data item.

    reply
    0
  • Cancelreply