O'Reilly logo

MySQL® by Paul DuBois

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required