MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Trevor Harris Date:December 29 2000 3:46pm
Subject:RE: difference between ENUM and SET ??
View as plain text  
Cyrille

There are two major differences.

ENUM can have 1 (and only 1) value chosen from a list of members. This list
can have up to 65535 elements

SET, you can chose 0 to n values from your member list.  This list can have
only 64 members in though.

HTH

Trevor

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 Trevor Harris							NuSphere Corp.
 MySQL Instructor/Consultant					14 Oak Park
Bedford, MA 01730   USA
 E-mail: tharris@stripped					http://www.nusphere.com
 Tel	+1 781-280-4243
Fax	+1 781-280-4901
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



-----Original Message-----
From:	Cyrille Giquello [mailto:cyrille@stripped]
Sent:	Friday, December 29, 2000 7:45 AM
To:	mysql@stripped
Subject:	difference between ENUM and SET ??

Hi,
and Happy Christmas and Happy New Year to your computer & Familly ;oP

I read the documentation but I've some problem to understand the difference
between
ENUM and SET for create string field.

What is the fundamental difference ??

ThanX

--
 Cyrille / Ktaland

-----------------------------------------
- Pour votre MAC: http://TOUSOFT.COM/
-----------------------------------------

Encryption | Duncan Campbell | DST | Blacklisted 411 | ECHELON | 2600 | PGP
| Corsica |
NSA



--
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php" before
posting. To request this thread, e-mail mysql-thread60161@stripped

To unsubscribe, send a message to:
    <mysql-unsubscribe-tharris=nusphere.com@stripped>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php

Thread
difference between ENUM and SET ??Cyrille Giquello29 Dec
  • Re: difference between ENUM and SET ??Gerald L. Clark29 Dec
  • RE: difference between ENUM and SET ??Trevor Harris29 Dec