开发者

How many values is possible in enum datatype of mysql?

开发者 https://www.devze.com 2023-03-23 22:55 出处:网络
How many values could be used in enum datatype in mysql ?I meant like emum(\'yes\',\'no\') ,here yes,noare values ,how many of these could be possible wit开发者_JAVA百科h enum A quick lookup shows it\

How many values could be used in enum datatype in mysql ? I meant like emum('yes','no') ,here yes,no are values ,how many of these could be possible wit开发者_JAVA百科h enum


A quick lookup shows it's a max of 65535 elements. See the MySQL documentation.


http://dev.mysql.com/doc/refman/5.1/en/enum.html

An enumeration can have a maximum of 65,535 elements.

as of MySQL 5.0 - 5.6


According to this doc,

An enumeration can have a maximum of 65,535 elements.


An enumeration can have a maximum of 65,535 elements.

Source: http://dev.mysql.com/doc/refman/5.0/en/enum.html


An enumeration can have a maximum of 65,535 elements.

REFERENCE

0

精彩评论

暂无评论...
验证码 换一张
取 消