[MySQL Database]

[Cydh]

first, I don't know the correct section to post.

 

about item identify value, it's only contains 0 and 1, or there is something else by default?

why don't use enum for it? now is using smallint:6

 

if identify only 0 or 1 is using smallint:6, why refine that 0~20 is tinyint:3?

 

Integer Types (Exact Value)

 

[solid2005]

because they using standard format enum is not available on MSSQL.

[goddameit]

I think we can use tinyint(1) or bit(1)

Edited April 25, 2013 by goddameit

[Fanny]

I think you can use tinyint(1) or bool type.

enum is a string type data with a value

For example, ENUM('a', 'b', 'c')

a's value is 1, b's value is 2, and c's value is 3

so it's not suitable for use enum here.

Edited July 5, 2013 by Fanny