What does the enum type refer to in mysql

In this article Xiaobian for you to introduce in detail "what the enum type refers to in mysql", the content is detailed, the steps are clear, the details are handled properly, I hope this article "what the enum type in mysql refers to" can help you solve your doubts, the following follows the editor's ideas slowly in depth, together to learn new knowledge.

Description

1. Enumerated types whose value ranges need to be displayed by enumerations when creating the table.

2. Enum ignores case. It is also supported to insert data through the subscript (starting from 1, the subscript crosses the bounds). A special value of 0 indicates a null value.

Example

-- create a table te that contains fields F1 (enum ('axia') mysql > create table te (f1 enum);-- insert several records mysql > insert into te values (' a'), ('B'), ('3'), (null) into the table After reading this, the article "what does the enum type in mysql refer to" has been introduced. If you want to master the knowledge of this article, you still need to practice and use it yourself to understand it. If you want to know more about related articles, you are welcome to follow the industry information channel.