This didn't mention that check constraints are completely ignored. That one bit me pretty hard the last time I tried to use MySQL. For whatever reason, app de

This didn't mention that check constraints are completely ignored. That one bit me pretty hard the last time I tried to use MySQL. For whatever reason, app developers kept getting longitude and latitude backwards. I wrote a check constraint that prevented that from being possible (in many cases), so if an app was doing it backwards, the DB would reject it. I ended up losing data (in dev -- which really meant I lost 45 minutes in having to restore it) in testing this. Then I read the docs. I expect things to do what I tell them too frequently.