:-) 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
|
+-+---+
