List:General Discussion« Previous MessageNext Message »
From:Victor Subervi Date:January 6 2010 6:40pm
Subject:Re: Another Inserting Multiple Values with Set Problem
View as plain text  
On Wed, Jan 6, 2010 at 2:34 PM, Hassan Schroeder <hassan.schroeder@stripped
> wrote:

> On Wed, Jan 6, 2010 at 1:25 PM, Victor Subervi <victorsubervi@stripped>
> wrote:
>
> > mysql> 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", ShipPercentPrice="5", ShipPercentWeight="2",
> > 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') where ID="2";
> > Query OK, 1 row affected, 2 warnings (0.00 sec)
> > Rows matched: 1  Changed: 1  Warnings: 2
> >
> > mysql> show warnings;
> >
> +---------+------+---------------------------------------------------------------+
> > | Level   | Code |
> > Message                                                       |
> >
> +---------+------+---------------------------------------------------------------+
> > | Warning | 1265 | Data truncated for column 'sizes' at row
> > 1                    |
> > | Warning | 1265 | Data truncated for column 'colorsShadesNumbersShort'
> at
> > row 1 |
> >
> +---------+------+---------------------------------------------------------------+
> > 2 rows in set (0.00 sec)
> >
> > Guess again.
>
> Hardly a guess, that syntax works fine for me:
>
> mysql> update jeweleryproducts set audience = ('women,seniors') where
> product = 'E30123E';
> Query OK, 0 rows affected (0.00 sec)
> Rows matched: 1  Changed: 0  Warnings: 0
>
> mysql> select product, audience from jeweleryproducts where product =
> 'E30123E';
> +---------+---------------+
> | product | audience      |
> +---------+---------------+
> | E30123E | women,seniors |
> +---------+---------------+
> 1 row in set (0.00 sec)
>
> mysql>
>

Works well *only* for one entry! Not multiple entries.

>
> What's the `create table` look like for the table in question?
>

mysql> describe products;
+--------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| Field                    |
Type
| Null | Key | Default | Extra          |
+--------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
| ID                       | tinyint(5)
unsigned
| NO   | PRI | NULL    | auto_increment |
| SKU                      |
varchar(40)
| NO   | UNI | NULL    |                |
| Category                 |
varchar(40)
| YES  |     | NULL    |                |
| Name                     |
varchar(50)
| NO   |     | NULL    |                |
| Title                    |
varchar(100)
| NO   |     | NULL    |                |
| Description              |
mediumtext
| NO   |     | NULL    |                |
| Price                    |
float(8,2)
| YES  |     | NULL    |                |
| SortFactor               |
int(4)
| YES  |     | 500     |                |
| Availability             |
tinyint(1)
| NO   |     | 1       |                |
| OutOfStock               |
tinyint(1)
| NO   |     | 0       |                |
| Weight                   |
float(7,2)
| NO   |     | 0.00    |                |
| ShipFlatFee              |
float(5,2)
| NO   |     | 10.00   |                |
| ShipPercentPrice         | tinyint(2)
unsigned
| NO   |     | 5       |                |
| ShipPercentWeight        | tinyint(2)
unsigned
| NO   |     | 2       |                |
| pic0                     |
mediumblob
| YES  |     | NULL    |                |
| pic1                     |
mediumblob
| YES  |     | NULL    |                |
| sizes                    |
set('Extra-small','Small','Medium','Large','XLarge','XXLarge','XXXLarge')
| YES  |     | NULL    |                |
| colorsShadesNumbersShort |
set('blue:333399','gray:465945','purple:50404D','navy-blue:CC7722','fuchsia:FF77FF','aqua:7FFFD4','maroon:B03060','black:0000FF','yellow:9ACD32')
| YES  |     | NULL    |                |
+--------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+------+-----+---------+----------------+
18 rows in set (0.00 sec)

V

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