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
