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

Reply via email to