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 Regards, -- Don Read don_r...@att.net It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org