Essay [MySQL] [Basic knowledge] [MySQL basic data type]

Data type classification

• MySQL data types are divided into five categories, integer type, floating-point type, String type, date type, and other data types.
• Integer type: bit, bool, tiny int, small int, Mediun int, int, big int
• Floating-point type: float, double, decimal
• String type: char, varchar, tiny text, text, medium text, long text, tiny blob, blob, media blob, long blob
• Date types: Date, datetime, timestamp, time, year
• Other data types: binary, varbinary, enum, set, geometry, point, multipoint, linestring, multilinestring, Polygon, GeometryCollection

Plastic

• Unsigned adornments are in the back. tinyint unsigned

Date type

• Date, time, datetime, timestamp

Essay [MySQL] [Basic knowledge] [MySQL basic data type]