Re: ENUM() vs TINYINT
- Date: Mon, 21 Sep 2015 16:53:49 -0500
- From: Basil Daoust <basil.daoust@xxxxxxxxx>
- Subject: Re: ENUM() vs TINYINT
I'm sure your enum is a fine option, but 0,1,2,3,4 would do the same thing.
And you could add a comment to the table to describe it if desired.
On Mon, Sep 21, 2015 at 8:03 AM, Richard Reina <gatorreina@xxxxxxxxx> wrote:
> I have a column name quarter which I need to have 5 possible inputs; 1, 2,
> 3, 4, or OT. Because of the OT possibility I am leaning towards ENUM.
> Hence, I am also thus considering ENUM('first', 'second', 'third',
> 'fourth', 'overtime') as the input will primarily be used in written
> descriptions. Is this a wise or unwise way to design a table column?