MySQL supports a large number of field types, many of which are commonly used. Numerical types can be divided into three subcategories: integer, floating point and fixed point. Always use integers, such as tinyint, int, bigint. By default, it is signed. If you only need to store unsigned values, you can increase the unsigned property. There are two kinds of floating-point types, float and double, which store approximate values in the database. Fixed-point field type has one decimal, which is mainly used to store decimals with precision requirements.
String types char and varchar are the most commonly used. The date and time types supported by MySQL are year, time, date, date time and timestamp.