MySQL Database data type

CHAR (m) fixed-length string,m<=255; processing speed is fast;

varchar (m) variable-length string,m<=255;

int (m) integer, between 214783647 and 214783648, using unsigned, which means 0 to 4294967295;

Float (m,d) floating-point type, M, sum of length digits, d, number of digits to the right of the decimal point, float (4,2) 88.88 valid, 100.88, 10.4242 invalid data;

Date data

Text/blog can be saved to 65,535 characters, the difference, text is not case-sensitive, the blog is sensitivity to case;

Set multi-data value combination, maximum 64 specified data values, any data is a valid value for that data type, both Apple and Paer are valid values; Ex:set ("Apple", "Paer") is not null;

The enum is basically the same as set, but only one valid value, girl or Boy;ex:set ("Girl", "boy") is not null;

MySQL Database data type