Earlgray Earlgray - 7 months ago 10
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
UPDATE TABLE
SET WIDTH = WIDTH * 10