Schema optimization and indexing

Special types of data

Some special types of data may not be directly compatible with the MySQL built-in type. One example is to use Stamptime to store more accurate time.

Another example is the IP address. People often use varchar (15) to store IP addresses. However, an IP address is actually an unsigned 32bit integral type, not a string. The IP address is just a bit more convenient for people to read IP addresses. You should use unsigned integers to store IP addresses. MySQL provides the Inet_aton () and Inet_ntoa () functions to resolve both types of conversions. Later versions of MySQL. It provides a data type that is dedicated to storing IP addresses.