List:General Discussion« Previous MessageNext Message »
From:Benjamin Pflugmann Date:May 11 1999 2:25am
Subject:Re: How to insert a set
View as plain text  
Hi.

The correct syntax for values of a set is:

insert into route (days) values ('Sun,Mon');

Bye,

	Benjamin.

On Mon, May 10, 1999 at 11:56:32PM +0200, mariuss@stripped wrote:
>     Hi folks.
> 
> I've run into a problem. I'm evaluating
>     Ver 9.29 Distrib 3.22.16a-gamma, for pc-solaris2.6 (i386)
> and created the field *days* of a set type:
>     days set ("Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat")
> 
> The problem is that I cannot insert a value for the field:
> insert into route (days) values ('Sun','Mon');
> 
> mysql issues an error about incorrect SQL syntax :(
> 
> I can insert one value from the set:
>     insert into route (days) values ('Mon')
> 
> but this does not solves the problem :((
> 
> Any suggestion would be highly appreciated.
> 
> 
> 
> 
> 
> --
>  Marius Strumyla
>  programmer
>  No Magic, Inc.
>  mailto:mariuss@stripped
>  http://www.nomagic.com
> 
> 
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread3140@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.

Attachment: [application/pgp-signature]
Thread
How to insert a setMarius Strumyla11 May
  • Re: How to insert a setBenjamin Pflugmann11 May