MySQL枚举类型enum字段在插入不在指定范围的值时, 是否是”插入了enum的第一个值”?…「建议收藏」

mysql> create table test(gender enum('M', 'F'));
Query OK, 0 rows affected (0.12 sec)

mysql> desc test;
+--------+---------------+------+-----+---------+-------+
| Field  | Type          | Null | Key | Default | Extra |
+--------+---------------+------+-----+---------+-------+
| gender | enum('M','F') | YES  |     | NULL    |       |
+--------+---------------+------+-----+---------+-------+
1 row in set (0.03 sec)

mysql> insert into test values('M'),('1'),('f'),(null);
Query OK, 4 rows affected (0.07 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> select * from test;
+--------+
| gender |
+--------+
| M      |
| M      |
| F      |
| NULL   |
+--------+
4 rows in set (0.00 sec)

mysql>

INSERT ignore INTO user (sex) VALUES (5);