MYSQL DATA TYPES

MYSQL DATA TYPES

MYSQL DATA TYPES

MySQL there are three main types text, number, and Date/ Time types.

MYSQL DATA TYPES

Text types:

Data type                         Description

CHAR(size)                     Holds a fixed length

                                        string (can contain

                                        letters, numbers, and

                                        special characters). The

                                        fixed size is specified in

                                        parenthesis.Can store up

                                        To255 characters

VARCHAR(Size)              Holds a variable length

                                         string (can contain

                                         letters, numbers, and

                                         special characters).The

                                         maximum size is

                                         specified in parenthesis

                                         Can store up to 255

                                         characters.

TINYTEXT                Holds a string with a

                                  maximum length of 255

                                  characters

TEXT                         Holds a string with a

                                  maximum length of

                                  65,535 characters

BLOB                        For BLOBs (Binary Large

                                 OBjects).Holds up to

                                  65,535 bytes of data

MEDIUMTEXT                        Holds a string with a

                                                maximum length of

                                                16,777,215 characters

MEDIUMBLOB                       For BLOBs Binary Large

                                               OBjects Hold s up to

                                               16,777.215 bytes of data

LONGTEXT                            Holds a string with a

                                               maximum length of

                                               4,294,967295 characters

LONGBLOB                           For BLOBs (Binary Large

                                               OBjects)Holds up to

                                               4,294,967,295 bytes of data

ENUM(Xx.y.z.etc.)                           Let you enter a list of

                                                        possible values. You can

                                                        list up to 65535 values in

                                                        an ENUM list. If value is

                                                        inserted that is not in the

                                                        list, a blank value will be

                                                        inserted.

                                                        Note: The values are

                                                        sorted in the order you

                                                        enter them.

                                                        You enter the possible

                                                        values in this format:

                                                        ENUM(’X’,Y’,Z’)

SET                                                Similar to ENUM except

                                                       that SET may contain up

                                                       to 64 list items and can

                                                       store more than one

                                                       choice