MySQL 5.7+ STRICT mode

If you have a project that is so old and so broken but you have to maintain anyway, but you are developing locally using MySQL 5.7+, just run this on your MySQL console to remind yourself how poorly coded your codebase is everyday!

> set global SQL_MODE="NO_ENGINE_SUBSTITUTION";

The next day, run it again and again and again, until your team fixes the codebase.

This entry was posted in MySQL. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *