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
