Hi
> mysql> SELECT prezzo, totale FROM ordini WHERE numordine=1157;
> mysql> UPDATE ordini SET prezzo = prezzo/1.024, totale = totale/1.024
> WHERE numordine>1385 AND dataord<'2003-06-01';
You are selecting data for numordine = 1157, but are updating all records
that have
numordine > 1385. 1157
* 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
