CodingForums.com - View Single Post - How we can represent ENUMs and SETs internally?

Old Pedant · 01-20-2013, 05:28 AM

Ummm...

Code:

CREATE TABLE yourtable (
    ageRange ENUM( 'infant', 'toddler', 'child', 'preteen', 'teen', 
                   'young adult', 'adult', 'milddle-aged', 'senior', 'ancient', 'old-pedant' )
);

So enums are easy. But now what KIND of sets are you talking about?

MySQL has a very silly SET datatype, but I don't think it is what you are looking for. But just in case:
http://dev.mysql.com/doc/refman/5.5/en/set.html

01-20-2013, 05:28 AM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,188 Thanks: 59 Thanked 3,995 Times in 3,964 Posts	Ummm... Code: CREATE TABLE yourtable ( ageRange ENUM( 'infant', 'toddler', 'child', 'preteen', 'teen', 'young adult', 'adult', 'milddle-aged', 'senior', 'ancient', 'old-pedant' ) ); So enums are easy. But now what KIND of sets are you talking about? MySQL has a very silly SET datatype, but I don't think it is what you are looking for. But just in case: http://dev.mysql.com/doc/refman/5.5/en/set.html __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.