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 <[EMAIL PROTECTED]>
>>>To unsubscribe, e-mail
>>><[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
>>To unsubscribe, e-mail
>><[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
