On 8/20/2012 10:09 AM, Mogens Melander wrote:
On Sun, August 19, 2012 18:19, william drescher wrote:
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I (usin
On Sun, August 19, 2012 18:19, william drescher wrote:
> On 8/17/2012 12:13 PM, Rik Wasmus wrote:
>>> I get 1 row affected, but the status does not change when I look
>>> at the row.
>>>
>>> If I set it to 'X' it does change.
>>>
>>> To make it even more wacky, if I (using phpMyAdmin) change it to
On 8/19/2012 5:56 PM, william drescher wrote:
mysql> select status from tasks;
++
| status |
++
| W |
++
1 row in set (0.00 sec)
mysql> update tasks set status= 'H';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed 1 Warnings: 0
mysql> select status f
On 8/19/2012 1:25 PM, Johnny Withers wrote:
The client indicates a warning after the update. Issue a show warnings
after the update.
actually, it doesn't.
but I did a show warnings and it replied: Empty Set (0.00 sec)
I also did a show triggers and it replied: Empty Set (0.00 sec)
On Aug 19,
The client indicates a warning after the update. Issue a show warnings
after the update.
On Aug 19, 2012 11:19 AM, "william drescher"
wrote:
> On 8/17/2012 12:13 PM, Rik Wasmus wrote:
>
>> I get 1 row affected, but the status does not change when I look
>>> at the row.
>>>
>>> If I set it to 'X'
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I (using phpMyAdmin) change it to
'H' it will change and the row is shown change, but when I go to
examine the
> I get 1 row affected, but the status does not change when I look
> at the row.
>
> If I set it to 'X' it does change.
>
> To make it even more wacky, if I (using phpMyAdmin) change it to
> 'H' it will change and the row is shown change, but when I go to
> examine the row (using the pencil icon=
I have a table ("tasks") with:
task_id mediumint(9)
status char(1)
priority char(1)
and more fields
when I do the following (using phpMyAdmin):
update tasks
set status='H'
where task_id='1'
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it d
On Fri, Dec 11, 2009 at 6:40 PM, Victor Subervi wrote:
>
> I'm lost. I set up this database originally with auto_increment and the
> first value was 0. I thought that was always the case. Is there a problem
> here?
>
Yes, that should not have happened. For autoincrement fields, both NULL and
0 ar
On Fri, Dec 11, 2009 at 8:43 AM, Johan De Meersman wrote:
> On Fri, Dec 11, 2009 at 11:19 AM, Mark Goodge
> wrote:
>
> > Jørn Dahl-Stamnes wrote:
> >
> >> On Friday 11 December 2009 10:38, Victor Subervi wrote:
> >>
> >>> Hi;
> >>>
> >>> mysql> update products set sizes="('Small', 'Large')" where
On Fri, Dec 11, 2009 at 11:19 AM, Mark Goodge wrote:
> Jørn Dahl-Stamnes wrote:
>
>> On Friday 11 December 2009 10:38, Victor Subervi wrote:
>>
>>> Hi;
>>>
>>> mysql> update products set sizes="('Small', 'Large')" where ID=0;
>>> Query OK, 0 rows affected, 1 warning (0.00 sec)
>>> Rows matched: 1
On Fri, Dec 11, 2009 at 5:33 AM, wrote:
>
> On Fri, 11 Dec 2009 05:28:41 -0500, Victor Subervi
>
> wrote:
> > On Fri, Dec 11, 2009 at 5:13 AM, wrote:
> >
> >>
> >> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
> >>
> >> wrote:
> >>
> >> > mysql> update products set sizes="('Small', 'Large
On Fri, 11 Dec 2009 05:28:41 -0500, Victor Subervi
wrote:
> On Fri, Dec 11, 2009 at 5:13 AM, wrote:
>
>>
>> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
>>
>> wrote:
>>
>> > mysql> update products set sizes="('Small', 'Large')" where
>> SKU='prodSKU1';
>> > Query OK, 0 rows a
On Fri, Dec 11, 2009 at 5:13 AM, wrote:
>
> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
>
> wrote:
>
> > mysql> update products set sizes="('Small', 'Large')" where
> SKU='prodSKU1';
> > Query OK, 0 rows affected, 1 warning (0.00 sec)
> > Rows matched: 1 Changed: 0 Warnings: 1
> >
> > m
Quoting cars...@bitbybit.dk:
Of course you can have ID=0.
Definately agree
mysql> DESCRIBE test;
+-+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---
day, December 11, 2009 6:13 PM
Subject: Re: Update Doesn't Update!
>
> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
>
> wrote:
>
>> mysql> update products set sizes="('Small', 'Large')" where
> SKU='prodSKU1';
>> Qu
Jørn Dahl-Stamnes wrote:
On Friday 11 December 2009 10:38, Victor Subervi wrote:
Hi;
mysql> update products set sizes="('Small', 'Large')" where ID=0;
Query OK, 0 rows affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 1
Look at the
On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
wrote:
> mysql> update products set sizes="('Small', 'Large')" where
SKU='prodSKU1';
> Query OK, 0 rows affected, 1 warning (0.00 sec)
> Rows matched: 1 Changed: 0 Warnings: 1
>
> mysql> show warnings;
> +-+--+--
On Fri, 11 Dec 2009 10:48:59 +0100, Jørn Dahl-Stamnes
wrote:
> On Friday 11 December 2009 10:38, Victor Subervi wrote:
>> Hi;
>>
>> mysql> update products set sizes="('Small', 'Large')" where ID=0;
>> Query OK, 0 rows affected, 1 warning (0.00 sec)
>> Rows matched: 1 Changed: 0 Warnings:
On Fri, Dec 11, 2009 at 4:43 AM, wrote:
>
> On Fri, 11 Dec 2009 04:38:01 -0500, Victor Subervi
>
> wrote:
> > Hi;
> >
> > mysql> update products set sizes="('Small', 'Large')" where ID=0;
> > Query OK, 0 rows affected, 1 warning (0.00 sec)
> > Rows matched: 1 Changed: 0 Warnings: 1
>
> "Warnin
[mailto:victorsube...@gmail.com]
Sent: 11 December 2009 10:06
Cc: mysql@lists.mysql.com
Subject: Re: Update Doesn't Update!
On Fri, Dec 11, 2009 at 4:48 AM, Jørn Dahl-Stamnes
wrote:
> On Friday 11 December 2009 10:38, Victor Subervi wrote:
> > Hi;
> >
> > mysql> updat
mysql> update products set sizes="('Small', 'Large')" where ID=0;
Query OK, 0 rows affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 1
Look at the message, 0 rows changed and 1 warning.
You cannot have ID=0 if ID is an index.
Are you
On Fri, Dec 11, 2009 at 4:48 AM, Jørn Dahl-Stamnes
wrote:
> On Friday 11 December 2009 10:38, Victor Subervi wrote:
> > Hi;
> >
> > mysql> update products set sizes="('Small', 'Large')" where ID=0;
> > Query OK, 0 rows affected, 1 warning (0.00 sec)
> > Rows matched: 1 Changed: 0 Warnings: 1
>
On Fri, Dec 11, 2009 at 4:48 AM, Jørn Dahl-Stamnes
wrote:
> On Friday 11 December 2009 10:38, Victor Subervi wrote:
> > Hi;
> >
> > mysql> update products set sizes="('Small', 'Large')" where ID=0;
> > Query OK, 0 rows affected, 1 warning (0.00 sec)
> > Rows matched: 1 Changed: 0 Warnings: 1
>
On Friday 11 December 2009 10:38, Victor Subervi wrote:
> Hi;
>
> mysql> update products set sizes="('Small', 'Large')" where ID=0;
> Query OK, 0 rows affected, 1 warning (0.00 sec)
> Rows matched: 1 Changed: 0 Warnings: 1
Look at the message, 0 rows cha
On Fri, 11 Dec 2009 04:38:01 -0500, Victor Subervi
wrote:
> Hi;
>
> mysql> update products set sizes="('Small', 'Large')" where ID=0;
> Query OK, 0 rows affected, 1 warning (0.00 sec)
> Rows matched: 1 Changed: 0 Warnings: 1
"Warnings: 1"
do a SHOW WARNINGS immediately after you e
Hi;
mysql> update products set sizes="('Small', 'Large')" where ID=0;
Query OK, 0 rows affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 1
mysql> select sizes, colorsShadesNumbersShort from products where ID=0;
+---+--+
| sizes | colorsShadesNumbers
:-) didn't pay enough attention
Thanks
PaT!
-Messaggio originale-
Da: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Inviato: venerdì 6 giugno 2003 19.08
A: [EMAIL PROTECTED]
Cc: PaT!
Oggetto: Re: UPDATE doesn't work
On 6 Jun 2003 at 19:00, PaT! wrote:
> mysql> UPDATE o
hat have
numordine > 1385. 1157 < 1385. So you are not updating these records.
Best regards, Mikhail.
- Original Message -
From: "PaT!" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 06, 2003 19:00
Subject: UPDATE doesn't work
> Hi
&g
* PaT!
[...]
> I need to update some values in two fields 'prezzo' and 'totale' These
> are the values before the UPDATE
>
> mysql> SELECT prezzo, totale FROM ordini WHERE numordine=1157;
> +++
> | prezzo | totale |
> +++
> | 6.795 | 6.795 |
> | 13.835 | 13.835 |
>
On 6 Jun 2003 at 19:00, PaT! wrote:
> mysql> UPDATE ordini SET prezzo = prezzo/1.024, totale = totale/1.024
> WHERE numordine>1385 AND dataord<'2003-06-01'; Query OK, 1649 rows
> affected (0.10 sec) Rows matched: 1650 Changed: 1649 Warnings: 0
>
> These are the values after the UPDATE
>
> mysq
Hi
I'm running MySQL 4.0.13
MS Windows XP Prof
I've this problem:
A db with a table called 'ordini'
mysql> desc ordini;
+-+---+--+-++---
-+
| Field | Type | Null | Key | Default| Extra
|
+-+---+
32 matches
Mail list logo
