@vars in UPDATE-Statements

Dummkopf

Hi,

how can I declare a variable in an UPDATE-Query without having to set a column information?

The following example works, but needs to have a dummyColumn to set in order to have a possibility to declare @.

UPDATE
   table AS T
SET
   T.dummyColumn = @test:= 15,
   T.realColumn = @test

But I want to have something like

UPDATE
   table AS T
SET
   @test := 15,
   T.realColumn = @test

Please don't say "Set T.realColumn = 15" - my situation is more complex and I just need to know how a variable can be declared without a dummy-column. 😉

Thx for your advises!

Dummkopf

I edited my post because I found the mistake I did. I still need help. The headline of this topic can also be given to the problem, which occurs now, so I didn't want to open a new topic. 🙂

Dummkopf

It can be done with

UPDATE
   table AS T
SET
   anyExistingColumn = anyExistingColumn + 0 * @test:= value,
   realColumn = @test

I don't consider that "clean", but it works without any dummy-columns. If you know a cleaner way, please post it! 🙂