Detailed introduction to mysql data types

Data type refers to the data characteristics of columns, stored procedure parameters, expressions and local variables. It determines the storage format of data and represents different information types.

#For example, float[(7,2)] means that there are 7 digits in total and 2 digits after the decimal point. Then the maximum number represented by this number is 99999.99

Selection principle, choose the most appropriate rather than the largest (the larger the data type, the larger the space it takes up).

#Char is a fixed-length type, such as char(5). For abc, if it is not five bytes, it will be filled with spaces.

varchar is a variable length type.

The above is the detailed introduction of mysql data types. For more related content, please pay attention to the PHP Chinese website (m.sbmmt.com)!