Data types for MySQL

Classification        notes and descriptions        data type       description binary data types store non-sub-characters and text data BLOBs       available to store image text data type character data including any combination of letters, symbols,                or numeric characters      char       Fixed-length non-Unicode character data                        varchar        variable-length non-Unicode data text store long text information date and time date and time in single quotation mark Enter time datetime date       date                        datetime       Date and time numeric data This data contains only numbers,                including positive, negative, and floating-point numbers, int smallint float double  floating-point currency data type for financial data        Decimal       fixed number bit data type indicates yes/No data        bit       store boolean data type

Data types for MySQL