Detailed introduction to common data types in MySQL

Data type: The data type refers to the column, data characteristics of stored procedure parameters, expressions and local variables. It determines the storage format of the data and represents different information types. (Such as integers, characters, floating point numbers, dates, etc...)

Select the most reasonable when selecting the data type. ##The most appropriate data type, not the largest data type.

Five types of integers:

(integers are like -3,-2,-1,0,1,2,3 ,10, etc.)

For example, you can use the integer data type for age.

Floating point type:

For example, if the salary has a decimal point, use floating point type.

Date and time type:

Character type:

The above is the detailed content of Detailed introduction to common data types in MySQL. For more information, please follow other related articles on the PHP Chinese website!