B. Data Type Reference
This appendix describes the data types provided by MySQL. For more information on the use of each type, see Chapter 3, “Data Types.”
Type name specifications use 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 nonbinary string types.
• D represents the scale (number of digits following the decimal point) for numeric types that have a fractional part. ...
Get MySQL, 5th Edition 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.
