Data Types

Share this post!

Vote this!

Choosing the correct data type can lead to a better performing database, for example comparing numeric types takes less time than comparing character strings types because character string types have character set and collation considerations, also the smaller the data the faster it will be processed and less I/O is used making queries perform even better.
MySQL includes many of the ISO SQL 2003 standard data types and adds more data types of its own, the data types can be categorized by the following.        more...