On Fri, Jan 1, 2010 at 4:34 PM, Don Read <don_r...@att.net> wrote:
> On Fri, 1 Jan 2010 14:34:48 -0500 Victor Subervi said:
>
> > Hi;
> <snip>
>
> > The following insert chokes when I try to insert multiple values from the
> > sets:
> >
> > insert into products (SKU, Category, Name, Title, Description, Price,
> > SortFactor, Availability, OutOfStock, ShipFlatFee, ShipPercentPrice,
> > ShipPercentWeight, sizes, colorsShadesNumbersShort) values("prodSKU1",
> > "prodCat1", "name1", "title1", "descr", "12.34", "500", "1", "0",
> "10.00",
> > "5", "2", "Extra-small", "'aqua:7FFFD4', 'blue:333399'");
> >
>
> INSERT INTO products ...
> ..., ('aqua:7FFFD4', 'blue:333399'));
>
> http://dev.mysql.com/doc/refman/5.0/en/set.html
>
> Thanks
V
