Re: Using user variables in UPDATE?

[Ramalingam Chelliah]

Hi ,
I tried user variables within paranthesis ...
Will this help you ?

update import i, pricelists p
i._pricelist=( @pl:=substring_index(i.pricelist_currency, ' ', 1))
i._currency_code= p.currency_code
where i._pricelist=p.pricelist;

or just place the @pl value in where clause

where p.pricelist=substring_index(i.pricelist_currency, ' ', 1)

There is a note saying that user variables can be used in place of expressions...and a similar usage of user variables within paranthesis
in the man page
http://dev.mysql.com/doc/mysql/en/Variables.html

mysql> SELECT @t1:=(@t2:=1)+@t3:=4,@t1,@t2,@t3;


Hope this helps,

Regards,
Ram.