This appendix describes the data types provided by MySQL. More information on the use of each type is given in Chapter 3, “Data Types.” Changes in behavior since 5.0.0 are indicated in the descriptions for individual types.
Type name specifications are written using the following conventions:
Square brackets (
) in syntax descriptions indicate optional information.
M represents the maximum display width for integer types, the precision (number of significant digits) for floating-point and decimal types, the number of bits for
BIT, and the maximum length for string types. In string column definitions, the length is specified in bytes for binary string types and in characters for non-binary string types.
D represents ...