Appendix D. MySQL Column Types
When you create a table in MySQL, you must specify the data type for each column. This appendix documents all the column types that MySQL provides as of version 5.5.22 (current this writing).
In this reference, many column types can accept optional
parameters to further customize how data for the column is
stored or displayed. First, there are the M
and
D
parameters, which are indicated (in square brackets
when optional) immediately following the column type name.
The parameter M
is used to specify the display
size (that is, maximum number of characters) to be used by values in the
column. In most cases, this will limit the range of values that may be
specified in the column. M
may be any integer between 1 and 255. ...
Get PHP & MySQL: Novice to Ninja, 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.