SQL modify value of columns through addition [duplicate]

Question

Possible Duplicate:
How do I add to each row in MySQL?

This is probably really easy for most of you but I can't wrap my head around it. I have a column in my table that is of type Float. I want to modify the value of this column for each row by adding 15. For example, if the column's value for a particular row is 10, I want to add 15 to it to make the new value 25, and the same for each subsequent row.

I am attempting to use PHP to do this but is there a way to do this just straight SQL?

Dup. of stackoverflow.com/questions/3074355/…

Caffeinated
– Caffeinated

2012-09-23 23:28:45 +00:00
Commented Sep 23, 2012 at 23:28 — Caffeinated
– Caffeinated, Commented Sep 23, 2012 at 23:28

Glavić · Accepted Answer · 2012-09-23 23:29:06Z

2

UPDATE `tableName` SET `fieldName` = `fieldName` + 15

answered Sep 23, 2012 at 23:29

Glavić

43.6k13 gold badges79 silver badges108 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL modify value of columns through addition [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related