Forum Moderators: coopster

Message Too Old, No Replies

do you use multiple ENUM(0,1) or one SET(...)?

         

Xuefer

5:07 am on Mar 20, 2004 (gmt 0)

10+ Year Member



yes i know what's the different between 1 ENUM and 1 SET, on language level.
but what make u decide to use multiple ENUM or one SET?

hasApple ENUM(0,1),
hasBanana ENUM(0,1),
hasBug ENUM(0,1),
or:
has SET('Apple', 'Banana', 'Bug')

which is more esay to manage, or higher efficiency?

Xuefer

7:36 am on Mar 20, 2004 (gmt 0)

10+ Year Member



i found an article
[vbmysql.com...]