Re: business users services

[Rick James]

I always CREATE TABLE _without_ giving a width for INT. SHOW CREATE TABLE always comes back _with_ a width.

I believe the only reason for explicitly saying a width is if you also say ZEROFILL, which is a rarely used option.

DECIMAL needs the width and precision.

FLOAT/DOUBLE have an optional precision, but almost always it should _not_ be specified.

VARCHAR/VARBINARY require a width.

Those that require it, use it to specify the encoding in the rows. Those that should not have it, use it for other purposes.