When I use this syntax, the first state gets inserted into the field and the
others are ignored. Here is my exact SQL:
mysql> insert into contr
-> VALUES(
-> "", 0, "Hammer Whackers", "Bob Hammer",
-> "3390 Peachtree Rd.", "", "Atlanta",
-> "GA", "30326", "", "404-326-0200",
-> "", "[EMAIL PROTECTED]",
-> "http://www.hammerwhackers.com";,
-> "FL, SC, TN", "thehammer", "Hammer1", curdate());
Only "FL" shows up after the insert. All of the other fields come out as I
expect. The field with state abbreviations is the only one that is a data
type of set. I am using MySQL 3.23.47.
On Tuesday 23 April 2002 04:31 pm, Gerald Clark wrote:
> 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
---------------------------------------------------------------------
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
