Update multiple columns

[jamesd0142]

Hi this is wiered but i can't think how to do it...

I have a fully populated table (call it table1) which looks:

col01 | col02 | col03 | col04 | col05 | col06 |.........

Now what i want is to add a column (call it col07) and populate this with a combiantion of col02+col03+col04.

so it looks like this:

col01 | col02 | col03 | col04 | col05 | col06 | col07
...1.........2..........3..........4.........5.... ....6......234...

(ignore the full stops they are for display purposes)

i tried this query:

update table1
set col07 = (select col02+col03+col04 from table1)
 

this obviously doesnt work.
Error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.

so can any1 help...?

Cheers James

[amitpatel66]

Hi this is wiered but i can't think how to do it...

I have a fully populated table (call it table1) which looks:

col01 | col02 | col03 | col04 | col05 | col06 |.........

Now what i want is to add a column (call it col07) and populate this with a combiantion of col02+col03+col04.

so it looks like this:

col01 | col02 | col03 | col04 | col05 | col06 | col07
...1.........2..........3..........4.........5.... ....6......234...

(ignore the full stops they are for display purposes)

i tried this query:

update table1
set col07 = (select col02+col03+col04 from table1)
 

this obviously doesnt work.
Error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.

so can any1 help...?

Cheers James

Try this:

 
update table1
set col07 = col02+col03+col04
 
 

[jamesd0142]

Try this:

 
update table1
set col07 = col02+col03+col04
 
 

cheers m8 thats workin like a dream