Hi I know there'd be a reason, but I can't understand that..
mysql> select @valore:=rand(), @valore, @valore:="ciao", @valore; +-------------------+-------------------+-----------------+---------+ | @valore:=rand() | @valore | @valore:="ciao" | @valore | +-------------------+-------------------+-----------------+---------+ | 0.483624490428366 | 0.483624490428366 | ciao | 0 | +-------------------+-------------------+-----------------+---------+ 1 row in set (0.00 sec) mysql> select @valore:=rand(), @valore, @valore:="ciao", @valore; +-------------------+-------------------+-----------------+---------+ | @valore:=rand() | @valore | @valore:="ciao" | @valore | +-------------------+-------------------+-----------------+---------+ | 0.747058809499311 | 0.747058809499311 | ciao | ciao | +-------------------+-------------------+-----------------+---------+ 1 row in set (0.00 sec) why in the first execution the latest value is 0 and not 'ciao'? and why in the first 2 columns the variables seems works as expected!? thank you in advance bye MAS! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
