On Fri, Jan 8, 2010 at 9:29 AM, Thiyaghu CK wrote:
> Hi Victor,
>
> Take out the double quotes from[ "('Small,Medium,XSmall')",
> "('teal_E2725B,black_FF,yellow_9ACD32')"]. Its working fine for me.
>
> mysql> insert into products (sizes, colorsShadesNumbersShort)
> values(('Small,Medium,XSmal
Hi Victor,
Take out the double quotes from[ "('Small,Medium,XSmall')",
"('teal_E2725B,black_FF,yellow_9ACD32')"]. Its working fine for me.
mysql> insert into products (sizes, colorsShadesNumbersShort)
values(('Small,Medium,XSmall'), ('teal_E2725B,black_FF,yellow_9ACD32'));
Query OK, 1 row
On Fri, Jan 8, 2010 at 2:26 AM, Thiyaghu CK 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
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)
Regards,
Thiyaghu CK
www.mafiree.com
On Fri, J
OK, guys, I'm totally confused:
mysql> insert into products (SKU, Category, Name, Title, Description, Price,
SortFactor, Availability, OutOfStock, Weight, ShipFlatFee, ShipPercentPrice,
ShipPercentWeight, sizes, colorsShadesNumbersShort) values ("prodSKU1",
"prodCat1", "name1", "title1", "descr",
mysql> create table t (sizes
set('Extra-small','Small','Medium','Large','XLarge','XXLarge','XXXLarge'),
colorsShadesNumbersShort
set('blue:99','gray:465945','purple:50404D','navy-blue:CC7722','fuchsia:FF77FF','aqua:7FFFD4','maroon:B03060','black:FF','yellow:9ACD32'));
On Wed, Jan 6, 2010 at 2:40 PM, Michael Dykman wrote:
> How about you show us the schema for the table so we know what is
> defined as what?
>
Done in last email.
>
> Also, as the update does succeed, it would be interesting to see what
> value actually got stored. After you have accounted for
How about you show us the schema for the table so we know what is
defined as what?
Also, as the update does succeed, it would be interesting to see what
value actually got stored. After you have accounted for each bit in
the stored value, we might have a clue about what is being truncated.
One t
On Wed, Jan 6, 2010 at 2:34 PM, Hassan Schroeder wrote:
> On Wed, Jan 6, 2010 at 1:25 PM, Victor Subervi
> wrote:
>
> > mysql> update products set SKU="prodSKU2", Category="prodCat1",
> > Name="name2", Title="title2", Description="descr", Price="22.55",
> > SortFactor="500", Availability="1", Ou
On Wed, Jan 6, 2010 at 2:18 PM, Hassan Schroeder wrote:
> On Wed, Jan 6, 2010 at 11:39 AM, Victor Subervi
> wrote:
>
> > Here's my example again. Syntactically correct. From my original post:
> >
> > update products set SKU="prodSKU2", Category="prodCat1", Name="name2",
> > Title="title2", Descr
On Wed, Jan 6, 2010 at 12:14 PM, Michael Dykman wrote:
> so you dropped the quotes around the unneccessarily bracketed
> expression? It's hard to diagnose when your example isn't even what
> you think is syntactically correct.
>
Here's my example again. Syntactically correct. From my original p
so you dropped the quotes around the unneccessarily bracketed
expression? It's hard to diagnose when your example isn't even what
you think is syntactically correct.
I can't find a reference, but i recall there is some limit on the
length of SET member identifiers.. some of yours look longish, m
On Wed, Jan 6, 2010 at 10:56 AM, Michael Dykman wrote:
> I don't really use sets when I can avoid them (too much special
> wierdness) but from the manual I see this:
>
> mysql> INSERT INTO myset (col) VALUES
> -> ('a,d'), ('d,a'), ('a,d,a'), ('a,d,d'), ('d,a,d');
> Query OK, 5 rows affected (0.01
Hi;
The following doesn't work with or without enclosing the sets in quotes:
update products set SKU="prodSKU2", Category="prodCat1", Name="name2",
Title="title2", Description="descr", Price="22.55", SortFactor="500",
Availability="1", OutOfStock="0", Weight="5.5", ShipFlatFee="10.0",
ShipPercentP
14 matches
Mail list logo