ansaurus

Question

Answer 1

+6 A:

Are you just doing this for display, or do you want to update the table with the reduced values?

In the first case:

select (Col1 - 10) from table

In the second (assuming you want to update ALL rows):

update table set Col1 = (Col1 - 10)

djacobson 2010-07-30 23:51:50

+1: Faster than me

OMG Ponies 2010-07-31 00:09:18

Answer 2

+3 A:

How about:

 SELECT (MyCol - 10)
 From MyTable

p.campbell 2010-07-30 23:52:00

+1: Faster than I

OMG Ponies 2010-07-30 23:52:20

Thanks Ponies. That's twice now, but you've beaten me a handful of times ;)

p.campbell 2010-07-30 23:53:10

But slower than me, and with less content.In fact, UPDATE p.campbell SET posttime = djacobson's post time + 10;)

djacobson 2010-07-30 23:53:55

You forgot the WHERE clause. Now all hell will break lose.

strager 2010-07-31 00:00:17

How to subtract the same amounts to all values in a column?