The enumeration problem in mysql field

I added a new column enum, enum ('true', 'false') to the existing MySQL table. What I get is the default value for the whole table by default, "true" as the default value. I did not set anything by default, why is this happening?

+3
source share
1 answer

From the MySQL manual :

If an ENUM column is declared to allow NULL, a NULL value is a legal value for the column and the default value is NULL. If the ENUM column is declared NOT NULL, the default value is the first entry in the valid values ​​list.

+2
source

All Articles