On 6 Jun 2003 at 19:00, PaT! wrote:
mysql UPDATE ordini SET prezzo = prezzo/1.024, totale = totale/1.024
WHERE numordine1385 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
mysql SELECT
* 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
. 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
I'm running MySQL 4.0.13
MS Windows XP Prof
I've this problem:
A db with a table
:-) 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 ordini SET prezzo
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
|