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 | +-------------+---------------+------+-----+------------+--------------- -+ | id | int(11) | | PRI | NULL | auto_increment | | numordine | int(10) | | | 0 | | | descrizione | varchar(150) | | | | | | marca | varchar(250) | | | | | | modello | varchar(250) | | | | | | generica | varchar(250) | | | | | | quantita | int(10) | | | 0 | | | prezzo | decimal(10,3) | | | 0.000 | | | type | varchar(10) | | | | | | dataord | date | | | 0000-00-00 | | | nominativo | varchar(200) | | | | | | totale | decimal(10,3) | | | 0.000 | | | fromprev | int(11) | YES | | NULL | | | ptype | varchar(20) | YES | | NULL | | | idutente | int(11) | YES | | NULL | | | codcliente | varchar(8) | YES | | NULL | | | datamod | date | YES | | NULL | | +-------------+---------------+------+-----+------------+--------------- -+ 17 rows in set (0.00 sec) 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'; 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? The same query applied on a single row works perfectly. Any help is appreciated PaT!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
