List:General Discussion« Previous MessageNext Message »
From:Carsten Pedersen Date:January 6 2010 9:01pm
Subject:Re: Another Inserting Multiple Values with Set Problem
View as plain text  
mysql> create table t (sizes 
set('Extra-small','Small','Medium','Large','XLarge','XXLarge','XXXLarge'), 
colorsShadesNumbersShort 
set('blue:333399','gray:465945','purple:50404D','navy-blue:CC7722','fuchsia:FF77FF','aqua:7FFFD4','maroon:B03060','black:0000FF','yellow:9ACD32'));

                                            Query OK, 0 rows affected 
(0.00 sec)

mysql> insert into t values ('Large,Small', 'aqua:7FFFD4,fuchsia:FF77FF');
Query OK, 1 row affected (0.00 sec)

mysql> select * from t;
+-------------+----------------------------+
| sizes       | colorsShadesNumbersShort   |
+-------------+----------------------------+
| Small,Large | fuchsia:FF77FF,aqua:7FFFD4 |
+-------------+----------------------------+
1 row in set (0.01 sec)

mysql> update t set sizes= 
'Extra-small,Large,Small,Medium,XLarge,XXLarge,XXXLarge', 
colorsShadesNumbersShort= 
'aqua:7FFFD4,blue:333399,gray:465945,navy-blue:CC7722,black:0000FF,maroon:B03060,purple:50404D,yellow:9ACD32,fuchsia:FF77FF';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 0


mysql> select * from t\G
*************************** 1. row ***************************
                    sizes: 
Extra-small,Small,Medium,Large,XLarge,XXLarge,XXXLarge
colorsShadesNumbersShort: 
blue:333399,gray:465945,purple:50404D,navy-blue:CC7722,fuchsia:FF77FF,aqua:7FFFD4,maroon:B03060,black:0000FF,yellow:9ACD32
1 row in set (0.00 sec)

/ Carsten

Victor Subervi skrev:
> On Wed, Jan 6, 2010 at 2:40 PM, Michael Dykman <mdykman@stripped> 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 each bit in
>> the stored value, we might have a clue about what is being truncated.
>>
> 
> mysql> select sizes, colorsShadesNumbersShort from products;
> +-------------+--------------------------+
> | sizes       | colorsShadesNumbersShort |
> +-------------+--------------------------+
> | Extra-small | blue:333399              |
> | Extra-small | aqua:7FFFD4              |
> | Extra-small | blue:333399              |
> |             |                          |
> +-------------+--------------------------+
> 4 rows in set (0.00 sec)
> 
> Ain't nothin' getting stored.
> 
>> One thing I did just note: the hyphen in 'Extra-Small'.  Set
>> identifiers need to be valid mysql identifiers and the hyphen '-' is
>> not a valid identifier character (as it is an arithmatic operator).  I
>> can't imagine that those colons in the colour list are healthy either.
>>
> 
> They all work except in a certain case where I had to pull the hyphen out. I
> can enter all of these products individually.
> 
>> The point of a set identifier to be an easy mnemonic for a particular
>> bit value.  Nothing is gained by trying to represent data with the
>> identifier itself.
>>
> 
> Huh? Please explain.
> V
> 
> 
> !DSPAM:451,4b44da73427881287616796!
> 
Thread
Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
  • Re: Another Inserting Multiple Values with Set ProblemMichael Dykman6 Jan
    • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
  • Re: Another Inserting Multiple Values with Set ProblemMichael Dykman6 Jan
    • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan
      • Re: Another Inserting Multiple Values with Set ProblemCarsten Pedersen6 Jan
        • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi8 Jan
          • Re: Another Inserting Multiple Values with Set ProblemThiyaghu CK8 Jan
            • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi8 Jan
              • Re: Another Inserting Multiple Values with Set ProblemThiyaghu CK8 Jan
                • Re: Another Inserting Multiple Values with Set ProblemVictor Subervi8 Jan
Re: Another Inserting Multiple Values with Set ProblemVictor Subervi6 Jan