On Fri, Jan 8, 2010 at 2:26 AM, Thiyaghu CK <theyaho...@gmail.com> wrote:
> Hi Victor,
>
> You have given space after the comma(shown here: ('Small, Medium,
> XSmall')). Take out the space and try, it will work.
>
> Example:
>
> mysql> insert into products(sizes) values ('Small,Medium,small,medium');
> Query OK, 1 row affected (0.05 sec)
>
insert into products (SKU, Category, Name, Title, Description, Price,
SortFactor, Availability, OutOfStock, Weight, ShipFlatFee, ShipPercentPrice,
ShipPercentWeight, sizes, colorsShadesNumbersShort) values("prodSKU1",
"prodCat1", "name1", "title1", "descr", "123.45", "500", "1", "0", "2.5",
"10.00", "5", "2", "('Small,Medium,XSmall')",
"('teal_E2725B,black_0000FF,yellow_9ACD32')");
mysql> select sizes from products;
+--------+
| sizes |
+--------+
| Medium |
+--------+
1 row in set (0.00 sec)
mysql> select colorsShadesNumbersShort from products;
+--------------------------+
| colorsShadesNumbersShort |
+--------------------------+
| black_0000FF |
+--------------------------+
1 row in set (0.00 sec)
It only entered one of each!! Please help.
V
