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