Help in mysql query

I have a database:

http://d.pr/86DH+

开发者_JS百科I want to divide all numbers in price column with 1.2 at once. It is possible?

Use this:

UPDATE tbl SET price = price / 1.2