How to prevent empty values of enum column in MySQL

Question

mysql> CREATE TABLE foo ( f ENUM('a', '123') );

mysql> insert into foo(f) value(3);
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> select * from foo;
+------+
| f    |
+------+
|      |
+------+

How to make it produce a failure when inserting a value out of range?

Answer 1

From 10.4.4. The ENUM Type

If strict SQL mode is enabled, attempts to insert invalid ENUM values result in an error.