Update complete col in same table - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Update complete col in same table

ampoampo Posts: 63Member
Hi.

How can I update a complete column in a table ?
I have a table with 2 columns: col_A and col_B and I want to add '1' to every cell of col_A.
Something like:
update tblName set col_A = ((select col_A from tblName)+1) ??

The +1 is less important the operation on all the cell is the issue.

10x.

Comments

  • ShanooShanoo Posts: 32Member
    : Hi.
    :
    : How can I update a complete column in a table ?
    : I have a table with 2 columns: col_A and col_B and I want to add '1' to every cell of col_A.
    : Something like:
    : update tblName set col_A = ((select col_A from tblName)+1) ??
    :
    : The +1 is less important the operation on all the cell is the issue.
    :
    : 10x.
    :

    Update tblName set col_A = col_A + 1
Sign In or Register to comment.