* 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 |
> | 17.578 | 17.578 |
> | 62.500 | 62.500 |
> +--------+--------+
> 4 rows in set (0.02 sec)
>
> this is the UPDATE query
>
> mysql> UPDATE ordini SET prezzo = prezzo/1.024, totale = totale/1.024
> WHERE numordine>1385 AND dataord<'2003-06-01';
^^^^^
This statement only updates rows with numordine>1385, your test records have
numordine=1157, which is smaller than 1385... :)
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
