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.
