List:General Discussion« Previous MessageNext Message »
From:Victor Subervi Date:January 6 2010 6:25pm
Subject:Re: Another Inserting Multiple Values with Set Problem
View as plain text  
On Wed, Jan 6, 2010 at 2:18 PM, Hassan Schroeder <hassan.schroeder@stripped
> wrote:

> On Wed, Jan 6, 2010 at 11:39 AM, Victor Subervi <victorsubervi@stripped>
> wrote:
>
> > Here's my example again. Syntactically correct. From my original post:
> >
> > update products set SKU="prodSKU2", Category="prodCat1", Name="name2",
> > Title="title2", Description="descr", Price="22.55", SortFactor="500",
> > Availability="1", OutOfStock="0", Weight="5.5", ShipFlatFee="10.0",
> > ShipPercentPrice="5", ShipPercentWeight="2", sizes="('Extra-small',
> 'Large',
> > 'Small', 'Medium', 'XLarge', 'XXLarge', 'XXXLarge')",
>
> Lose the enclosing double-quotes and put all the values within a
> single set of single quotes.
>
> > colorsShadesNumbersShort="('
> > aqua:7FFFD4', 'blue:333399', 'gray:465945', 'navy-blue:CC7722',
> > 'black:0000FF', 'maroon:B03060', 'purple:50404D', 'yellow:9ACD32',
> > 'fuchsia:FF77FF')"
>
> e.g. (shortened for lazyness):
>
> colorsShadesNumbersShort = ('aqua:7FFFD4, blue:333399')
>
> > where ID="2";
>
> mysql> update products set SKU="prodSKU2", Category="prodCat1",
Name="name2", Title="title2", Description="descr", Price="22.55",
SortFactor="500", Availability="1", OutOfStock="0", Weight="5.5",
ShipFlatFee="10.0", ShipPercentPrice="5", ShipPercentWeight="2",
sizes=('Extra-small, Large, Small, Medium, XLarge, XXLarge, XXXLarge'),
colorsShadesNumbersShort=('aqua:7FFFD4, blue:333399, gray:465945,
navy-blue:CC7722, black:0000FF, maroon:B03060, purple:50404D, yellow:9ACD32,
fuchsia:FF77FF') where ID="2";
Query OK, 1 row affected, 2 warnings (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 2

mysql> show warnings;
+---------+------+---------------------------------------------------------------+
| Level   | Code |
Message                                                       |
+---------+------+---------------------------------------------------------------+
| Warning | 1265 | Data truncated for column 'sizes' at row
1                    |
| Warning | 1265 | Data truncated for column 'colorsShadesNumbersShort' at
row 1 |
+---------+------+---------------------------------------------------------------+
2 rows in set (0.00 sec)

Guess again.
V

Thread
Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
  • Re: Another Inserting Multiple Values with Set ProblemMichael Dykman6 Jan
    • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
  • Re: Another Inserting Multiple Values with Set ProblemMichael Dykman6 Jan
    • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
      • Re: Another Inserting Multiple Values with Set ProblemCarsten Pedersen6 Jan
        • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi8 Jan
          • Re: Another Inserting Multiple Values with Set ProblemThiyaghu CK8 Jan
            • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi8 Jan
              • Re: Another Inserting Multiple Values with Set ProblemThiyaghu CK8 Jan
                • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi8 Jan
Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan