During my work with companies using MySQL, I have encountered many issues with regard to schema design, normalization and indexing. Of the most common errors are incorrect data types definition.
Here’s a compilation of “the right and the wrong” data types.