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  

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.



 Trevor Harris							NuSphere Corp.
 MySQL Instructor/Consultant					14 Oak Park
Bedford, MA 01730   USA
 E-mail: tharris@stripped
 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 ??

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
ENUM and SET for create string field.

What is the fundamental difference ??


 Cyrille / Ktaland

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

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

Please check "" before
posting. To request this thread, e-mail mysql-thread60161@stripped

To unsubscribe, send a message to:

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:

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