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