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
