List:General Discussion« Previous MessageNext Message »
From:Yang Wang Date:December 11 2009 10:21am
Subject:Re: Update Doesn't Update!
View as plain text  
first desc products

or try to

update products set sizes='Small' where
SKU='prodSKU1';




Best Regards!
Yang Wang
 
Tel.: 0769-21687397
Fax.: 0769-21685577
Email: ywang@stripped
----- Original Message ----- 
From: <carsten@stripped>
To: "Victor Subervi" <victorsubervi@stripped>
Cc: <mysql@stripped>
Sent: Friday, December 11, 2009 6:13 PM
Subject: Re: Update Doesn't Update!


> 
> 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...
> 
> / Carsten
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=ywang@stripped
>
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