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 <victorsube...@gmail.com> wrote: > On Wed, Jan 6, 2010 at 10:56 AM, Michael Dykman <mdyk...@gmail.com> 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 <victorsube...@gmail.com> >> wrote: >> > On Wed, Jan 6, 2010 at 10:23 AM, Michael Dykman <mdyk...@gmail.com> >> 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 <victorsube...@gmail.com >> > >> >> 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 >> >> - mdyk...@gmail.com >> >> >> >> May the Source be with you. >> > >> > >> > >> > -- >> > The Logos has come to bear >> > http://logos.13gems.com/ >> > >> >> >> >> -- >> - michael dykman >> - mdyk...@gmail.com >> >> May the Source be with you. >> > > > > -- > The Logos has come to bear > http://logos.13gems.com/ > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org