Standard (important) for mysql Data Types
1. allowed value: the range and type of values in a field are allowed to determine which data type is the most direct factor to add to this field.
2. storage efficiency: it is also important to consider the possible value range of a field and select an appropriate data type with proper size according to this range, especially when processing the value type.
3. Format and display requirements: another important factor affecting field type selection is the application format and display requirements of data stored in the field.
4. Data Processing Requirements: Data Type Selection should also consider the requirements of data operations and application processing. For example, some types are more suitable for accelerating data operations than others.
5. sorting, indexing, and comparison requirements: If you want different criteria to sort all values in a column, then we need to select a type that can effectively execute these functions and has the maximum flexibility. Adding indexes to corresponding fields can accelerate the search speed. The comparison type should also be used. Make sure that the data types used support comparison and are compatible with each other.