sets and enums

------=_NextPart_000_0005_01C6297C.DAD12160
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Anybody know how to set-up a set or an enum type in MySQL using the =
MySQL Administrator?

I entered field-type ENUM but that was as far as I got, because the =
Administrator returns an error when I click update. Need to know where =
to put the lookup table for the enum type as well.

Thanks in advance... and Have a great day!

Bill Angus, MA
http://www.psychtest.com
------=_NextPart_000_0005_01C6297C.DAD12160--

RE: sets and enums

Bill,

I just added ENUM('ON','OFF') to the data type when I created the table. I
did not receive an error. If you didn't enter the values At the time you
created the field, then that is probably why you got the error.

Here's the SQL that was created:

ALTER TABLE `myDatabase`.`tblTest` MODIFY COLUMN `id` INTEGER UNSIGNED NOT
NULL AUTO_INCREMENT,
ADD COLUMN `enumColumn` ENUM('ON','OFF') NOT NULL DEFAULT 'OFF' AFTER `id`
, COMMENT = 'Test Table';

Hope this helps!

Vic

-----Original Message-----
From: Bill Angus [mailto:mdangus@psychtest.com]
Sent: Saturday, February 04, 2006 11:19 AM
To: win32@lists.mysql.com
Subject: sets and enums

Anybody know how to set-up a set or an enum type in MySQL using the MySQL
Administrator?

I entered field-type ENUM but that was as far as I got, because the
Administrator returns an error when I click update. Need to know where to
put the lookup table for the enum type as well.

Thanks in advance... and Have a great day!

Bill Angus, MA
http://www.psychtest.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: sets and enums

------=_NextPart_000_0016_01C62A26.05A48630
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Thank you Vic. I didn't know where to put the 'ON','OFF' part -- and =
couldn't find the info in the docs. Your info much appreciated.

Bill Angus, MA
http://www.psychtest.com
----- Original Message -----=20
From: Vic Spainhower=20
To: 'Bill Angus' ; win32@lists.mysql.com=20
Sent: Saturday, February 04, 2006 4:06 PM
Subject: RE: sets and enums


Bill,

I just added ENUM('ON','OFF') to the data type when I created the =
table. I
did not receive an error. If you didn't enter the values At the time =
you
created the field, then that is probably why you got the error.

Here's the SQL that was created:

ALTER TABLE `myDatabase`.`tblTest` MODIFY COLUMN `id` INTEGER UNSIGNED =
NOT
NULL AUTO_INCREMENT,
ADD COLUMN `enumColumn` ENUM('ON','OFF') NOT NULL DEFAULT 'OFF' AFTER =
`id`
, COMMENT =3D 'Test Table';=20

Hope this helps!

Vic=20

-----Original Message-----
From: Bill Angus [mailto:mdangus@psychtest.com]=20
Sent: Saturday, February 04, 2006 11:19 AM
To: win32@lists.mysql.com
Subject: sets and enums

Anybody know how to set-up a set or an enum type in MySQL using the =
MySQL
Administrator?

I entered field-type ENUM but that was as far as I got, because the
Administrator returns an error when I click update. Need to know where =
to
put the lookup table for the enum type as well.

Thanks in advance... and Have a great day!

Bill Angus, MA
http://www.psychtest.com


--=20
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: =
http://lists.mysql.com/win32?unsub=3Dmdangus@psychtest.com


------=_NextPart_000_0016_01C62A26.05A48630--