Home » RDBMS Server » Server Administration » Adding value to existing value in column
Adding value to existing value in column [message #371028] Mon, 14 August 2000 14:19 Go to next message
me
Messages: 66
Registered: August 2000
Member
How do you add a value to an existing value in a column when updating a row?

Report message to a moderator

Re: Adding value to existing value in column [message #371030 is a reply to message #371028] Mon, 14 August 2000 15:23 Go to previous messageGo to next message
Vjeko
Messages: 15
Registered: August 2000
Junior Member
update table set col1=col1+5;

Report message to a moderator

Re: Adding value to existing value in column [message #371039 is a reply to message #371028] Wed, 16 August 2000 09:52 Go to previous message
Thavamani
Messages: 11
Registered: July 2000
Junior Member
update table
set col1 = col1 + 2
where <condt>

Report message to a moderator

Previous Topic: Re: Commit after certain # of rows inserted
Next Topic: Importing database from Win NT to UNIX
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 08:33:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.