Earlgray Earlgray - 1 year ago 65
SQL Question

How to multiply value in table column?

I have to edit table in my database. I have column

[Width]
and I have to multiply this
[Width] * 10
for all rows. How can I do it?

Answer Source
UPDATE TABLE
SET WIDTH = WIDTH * 10