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. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access