ansaurus

Question

changing data in mysql in bulk with a som

Answer 1

+2 A:

Use a query tool, like the MySQL command line client, the Query browser, or even phpMyAdmin and issue this statement

UPDATE product 
SET    price = ROUND(price + 1.5, 2)

assuming your table is called product and your column is called price

Roland Bouman 2009-12-31 12:03:15

Great thanks! I assume it's a one time statement, it won't be remebered with next inserts right?

Chris 2010-01-01 16:24:37

Yes. This operation modifies whatever is inside the table now. But running this statement again though will perform the math and the assignment again of course.

Roland Bouman 2010-01-01 16:26:49

yes, this means that allready assigned modifications wil be modified again right?

Chris 2010-01-01 16:36:50

Yes. Whenever you execute this statement, all rows will be modified, changing their price to whatever is the current price plus 1.5. "All rows" includes any rows that were previously modified by this statement. In a normal RDBMS rows only remember their current state - they know nothing about what brought about their current state

Roland Bouman 2010-01-02 11:32:35

ansaurus

tags:

views:

answers:

changing data in mysql in bulk with a som

related questions