Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Question Unanswered: Update 1 colum with the data of 2 colums in the same table.

    Hello,

    I'am new to databases, i hope someone can help me.

    I need to merge 2 colums from the same table, into a other colum in the same table. is this possible ? and how can i do it.

    a + b = ab

    I think it's a update or insert statement

    Thank for your help.

  2. #2
    Join Date
    Nov 2003
    Posts
    91
    UPDATE yourtable
    SET col_ab = col_a + col_b;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •