List:MySQL on Win32« Previous MessageNext Message »
From:Bill Angus Date:February 5 2006 3:30pm
Subject:Re: sets and enums
View as plain text  
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 ----- 
  From: Vic Spainhower 
  To: 'Bill Angus' ; win32@stripped 
  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 = 'Test Table'; 

  Hope this helps!

  Vic 

  -----Original Message-----
  From: Bill Angus [mailto:mdangus@stripped] 
  Sent: Saturday, February 04, 2006 11:19 AM
  To: win32@stripped
  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=1



Thread
sets and enumsBill Angus4 Feb
  • RE: sets and enumsVic Spainhower5 Feb
Re: sets and enumsBill Angus5 Feb