List:General Discussion« Previous MessageNext Message »
From:Victor Subervi Date:December 11 2009 10:47am
Subject:Re: Update Doesn't Update!
View as plain text  
On Fri, Dec 11, 2009 at 5:33 AM, <carsten@stripped> wrote:

>
> On Fri, 11 Dec 2009 05:28:41 -0500, Victor Subervi
> <victorsubervi@stripped>
> wrote:
> > On Fri, Dec 11, 2009 at 5:13 AM, <carsten@stripped> wrote:
> >
> >>
> >> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
> >> <victorsubervi@stripped>
> >> wrote:
> >>
> >> > mysql> update products set sizes="('Small', 'Large')" where
> >> SKU='prodSKU1';
> >> > Query OK, 0 rows affected, 1 warning (0.00 sec)
> >> > Rows matched: 1  Changed: 0  Warnings: 1
> >> >
> >> > mysql> show warnings;
> >> > +---------+------+--------------------------------------------+
> >> > | Level   | Code | Message                                    |
> >> > +---------+------+--------------------------------------------+
> >> > | Warning | 1265 | Data truncated for column 'sizes' at row 1 |
> >> > +---------+------+--------------------------------------------+
> >> > 1 row in set (0.00 sec)
> >> >
> >> >
> >> > What do? How do I enter multiple values?
> >>
> >> Impossible to say, until you let us know how you defined the column in
> >> the
> >> first place...
> >>
> >
> > Sorry. It's an enum of which the elements I am trying to add into a row
> are
> > elements of the same enum; that is, a subset.
>
> You're using the wrong type. RTFM re. the difference between enums and
> sets.
>

k. Thanks,
V

Thread
Update Doesn't Update!Victor Subervi11 Dec
  • Re: Update Doesn't Update!carsten11 Dec
    • Re: Update Doesn't Update!Victor Subervi11 Dec
      • Re: Update Doesn't Update!carsten11 Dec
        • Re: Update Doesn't Update!Victor Subervi11 Dec
          • Re: Update Doesn't Update!carsten11 Dec
            • Re: Update Doesn't Update!Victor Subervi11 Dec
  • Re: Update Doesn't Update!Jørn Dahl-Stamnes11 Dec
    • Re: Update Doesn't Update!Victor Subervi11 Dec
    • Re: Update Doesn't Update!Victor Subervi11 Dec
      • RE: Update Doesn't Update!misiaQ11 Dec
    • Re: Update Doesn't Update!carsten11 Dec
      • Re: Update Doesn't Update!Chris Knipe11 Dec
    • Re: Update Doesn't Update!Mark Goodge11 Dec
      • Re: Update Doesn't Update!Johan De Meersman11 Dec
        • Re: Update Doesn't Update!Victor Subervi11 Dec
          • Re: Update Doesn't Update!Johan De Meersman11 Dec
  • Re: Update Doesn't Update!Martijn Tonies11 Dec
  • Re: Update Doesn't Update!Yang Wang11 Dec