:-) 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 = 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 > > 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) > > Why the values didn't update? Your update query has "WHERE numordine > 1385", but 1157 isn't greater than 1385. Why would you expect the values to be updated? -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
