In MySQL 5.7, how can I make it so that when a value for an ENUM field (NN) is omitted in insert, an error is generated?

Question

MySQL

In non-strict and strict mode, if there is no value for an ENUM field (NOT NULL) in insert, then the first numbered member from the list of this ENUM is written to this field.
First, it is very strange that in this context, strict and non-strict modes do not differ. This is fine?
And secondly, how to make it as simple as possible, so that when a value for an ENUM field (NOT NULL) is omitted in insert, an error is generated?

Answer 1

Do you have a case for the DEFAULT field is not set?
PS
This is the regular behavior of MySQL:
So the check can be done only by hanging a trigger on BEFORE INSERT / BEFORE UPDATE with checking the value and generating an error through SIGNAL .