List:General Discussion« Previous MessageNext Message »
From:<carsten Date:December 11 2009 10:33am
Subject:Re: Update Doesn't Update!
View as plain text  
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. 

/ Carsten
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