B. Data Type Reference
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 the ...
Get MySQL® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
