I am trying to update a table with a file that has more than one update statements like this:
UPDATE products set products_price="22.00" WHERE products_model="5217-01" OR products_model="521701" AND products_um="CS"; UPDATE products set products_price="3" WHERE products_model="5217-01" OR products_model="521701" AND products_um="PK"; UPDATE products set products_price="0.25" WHERE products_model="5217-01" OR products_model="521701" AND products_um="EA"; In the products table the only record that exist with product_model="5217-01" has a products_um="CS" not "EA" but when my which contains the update statements is executed the last statement is the one that actually makes the change therefore resulting in the record to be products_price=0.25 instead of 22. Any ideas why this is happening? Shouldn't this statements just match the record and make the update? is there another way to do this? Thanks!
