Enum is not a function; it's a mysql data type. It's very useful when field
values are from the finite set.
Examples
CREATE table fanlist_try (ID bigint(21)
NOT NULL auto_increment, name varchar(50), email
varchar(70), age int(10), sex enum('male','female'), country
varchar(50), PRIMARY KEY (ID))
and field sex now can have only 2 values - 'male' and 'female'
the main reason to use it (instead of MySQL) is speed. The next one could be
data correctness
Valentin Petruchek (aki Zliy Pes)
*** Cut the beginning ***
http://zliypes.com.ua
mailto:[EMAIL PROTECTED]
----- Original Message -----
From: "Thomas Edison Jr." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, February 13, 2002 7:36 PM
Subject: Re: [PHP] Re-Importing .CSV file into Database
> Val,
>
> quite frankly, i'm not quite sure i know what you're
> talking about. i don't think i know enum() function!!
>
> T. Edison jr.
>
> --- val petruchek <[EMAIL PROTECTED]> wrote:
> > > Hi Rick,
> > >
> > > Thanks for the support!
> > > This is the mySQL Table Structure :
> > >
> > > $sql = "CREATE table fanlist_try (ID bigint(21)
> > NOT
> > > NULL auto_increment, name varchar(50), email
> > > varchar(70), age int(10), sex varchar(20), country
> > > varchar(50), PRIMARY KEY (ID))";
> >
> > sex varchar(20) sounds great. why do not use
> > enum('male','female')? or sex
> > has infinite set of possible values?
> >
> >
> > Valentin Petruchek (aki Zliy Pes)
> > *** Cut the beginning ***
> > http://zliypes.com.ua
> > mailto:[EMAIL PROTECTED]
> >
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> =====
> Rahul S. Johari (Director)
> ******************************************
> Abraxas Technologies Inc.
> Homepage : http://www.abraxastech.com
> Email : [EMAIL PROTECTED]
> Tel : 91-4546512/4522124
> *******************************************
>
> __________________________________________________
> Do You Yahoo!?
> Send FREE Valentine eCards with Yahoo! Greetings!
> http://greetings.yahoo.com
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
