List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:January 6 2010 4:14pm
Subject:Re: Another Inserting Multiple Values with Set Problem
View as plain text  
so you dropped the quotes around the unneccessarily bracketed
expression?  It's hard to diagnose when your example isn't even what
you think is syntactically correct.

I can't find a reference, but i recall there is some limit on the
length of SET member identifiers..  some of yours look longish, maybe?

 - md

On Wed, Jan 6, 2010 at 10:53 AM, Victor Subervi <victorsubervi@stripped> wrote:
> On Wed, Jan 6, 2010 at 10:56 AM, Michael Dykman <mdykman@stripped> wrote:
>
>> I don't really use sets when I can avoid them (too much special
>> wierdness) but from the manual I see this:
>>
>> mysql> INSERT INTO myset (col) VALUES
>> -> ('a,d'), ('d,a'), ('a,d,a'), ('a,d,d'), ('d,a,d');
>> Query OK, 5 rows affected (0.01 sec)
>>
>> mysql> SELECT col FROM myset;
>> +------+
>> | col  |
>> +------+
>> | a,d  |
>> | a,d  |
>> | a,d  |
>> | a,d  |
>> | a,d  |
>> +------+
>>
>> which suggests your syntax is in error.  It appears that it should be:
>>
>> 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";
>>
>> watch for the line-wraps in the SET data specifications..  I did both
>> of your sets (I assume colorsShadesNumbersShort is a set.. I don't
>> know what you are trying to do there.
>>
>
> No, that thew the same errors. I know you have to enclose the sets in
> parentheses and individually quote each element.
> V
>
>>
>>  - michael dykman
>>
>> On Wed, Jan 6, 2010 at 9:32 AM, Victor Subervi <victorsubervi@stripped>
>> wrote:
>> > On Wed, Jan 6, 2010 at 10:23 AM, Michael Dykman <mdykman@stripped>
>> wrote:
>> >>
>> >> What are the warnings?
>> >>
>> >> 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 |
>> >
>>
> +---------+------+---------------------------------------------------------------+
>> >
>> >>
>> >>
>> >> On Wed, Jan 6, 2010 at 9:04 AM, Victor Subervi
> <victorsubervi@stripped
>> >
>> >> wrote:
>> >> > Hi;
>> >> > The following doesn't work with or without enclosing the sets in
>> quotes:
>> >> >
>> >> > 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";
>> >> >
>> >> > Everything inserts but the sets which throw warnings. What am I
>> missing?
>> >> > TIA,
>> >> > Victor
>> >> >
>> >> > --
>> >> > The Logos has come to bear
>> >> > http://logos.13gems.com/
>> >> >
>> >>
>> >>
>> >>
>> >> --
>> >>  - michael dykman
>> >>  - mdykman@stripped
>> >>
>> >>  May the Source be with you.
>> >
>> >
>> >
>> > --
>> > The Logos has come to bear
>> > http://logos.13gems.com/
>> >
>>
>>
>>
>> --
>>  - michael dykman
>>  - mdykman@stripped
>>
>>  May the Source be with you.
>>
>
>
>
> --
> The Logos has come to bear
> http://logos.13gems.com/
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.
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