Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
01-19-2013, 03:18 PM #1
- Join Date
- Jan 2013
- Thanked 0 Times in 0 Posts
How we can represent ENUMs and SETs internally?
Currently I am facing problem with my database. want to represent ENUMs & SETs. does any one have any idea.
01-20-2013, 05:28 AM #2
CREATE TABLE yourtable ( ageRange ENUM( 'infant', 'toddler', 'child', 'preteen', 'teen', 'young adult', 'adult', 'milddle-aged', 'senior', 'ancient', 'old-pedant' ) );
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.htmlAn 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.