List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:May 18 1999 7:37pm
Subject:Re: ENUM and SET
View as plain text  
On Tue, May 18, 1999 at 11:52:31AM -0700, Dan Parisien wrote:
> Is it possible to fill up a set or ENUM with a select?

Nope.

> create table foo(id int not null, primary key(id), info ENUM(
> select name from namelist)
> 
> soemthing like that?

Do it in two statements.  The first selects the names from
namelist, then you string them together 'name1','name2','name3'
inside a variable.  Then you create the table using the contents
of that variable.

It's kind of ugly.  If your ENUM/SET values are already stored in
another table, then...maybe you shouldn't be using ENUM/SET?  But
who knows....

Tim
Thread
ENUM and SETDan Parisien18 May
  • Re: ENUM and SETThimble Smith18 May
  • Re: tables lockedTonu Samuel6 Jul
RE: tables lockedNoel Clarkson10 Jul
  • RE: tables lockedPatrick Premartin10 Jul