Strict mode should top the list. By default, MySQL hates your data and wants to quietly mangle it.
In fact ENUM is an especially bad idea without strict mode, because it converts any typo to the empty string, which is almost certainly not what you meant to store. This also happens behind your back whenever the database doesn't have the correct version of the schema...
In fact ENUM is an especially bad idea without strict mode, because it converts any typo to the empty string, which is almost certainly not what you meant to store. This also happens behind your back whenever the database doesn't have the correct version of the schema...