List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:April 23 2002 8:31pm
Subject:Re: insert for datatype of "set"
View as plain text  
insert into mytable ( id , myset) values ('1', 'GA,SC') , ( '2', 
'TN,NC,AL') ;

Jim Philips wrote:

>Yes. I found that page earlier. I still don't see how it answers my question. 
>What is the proper syntax for an insert statement?
>
>On Tuesday 23 April 2002 03:54 pm, Christopher Thompson wrote:
>
>>http://www.mysql.com/doc/S/E/SET.html
>>
>>On Tuesday 23 April 2002 1:45 pm, Jim Philips wrote:
>>
>>>I couldn't find this in the documentation. What is the propoer sql to
>>>insert into a field with a data type of set? My field has the following
>>>set of acceptable values:
>>>
>>>GA, TN, SC, NC, AL
>>>
>>>Assume I am inserting multiple values, such GA, TN, SC. If I separate
>>>them with commas, mysql will assume they are separate fields. So, what is
>>>the way out of this?
>>>
>>>---------------------------------------------------------------------
>>>Before posting, please check:
>>>   http://www.mysql.com/manual.php   (the manual)
>>>   http://lists.mysql.com/           (the list archive)
>>>
>>>To request this thread, e-mail <mysql-thread106912@stripped>
>>>To unsubscribe, e-mail
>>><mysql-unsubscribe-christ=axionspatial.com@stripped> Trouble
>>>unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>>
>>---------------------------------------------------------------------
>>Before posting, please check:
>>   http://www.mysql.com/manual.php   (the manual)
>>   http://lists.mysql.com/           (the list archive)
>>
>>To request this thread, e-mail <mysql-thread106913@stripped>
>>To unsubscribe, e-mail
>><mysql-unsubscribe-jcphil=mindspring.com@stripped> Trouble
>>unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread106914@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
insert for datatype of "set"Jim Philips23 Apr
  • Re: insert for datatype of "set"Christopher Thompson23 Apr
  • Re: insert for datatype of "set"Gerald Clark23 Apr
    • Re: insert for datatype of "set"Jim Philips23 Apr
  • Re: insert for datatype of "set"Harald Fuchs24 Apr
Re: insert for datatype of "set"Jim Philips23 Apr