From: MAS!
Date: October 4 2012 1:52pm
Subject: (real) silly question about variables...
List-Archive: http://lists.mysql.com/mysql/228315
Message-Id: <3F45B384-3E34-4D13-ACD6-B0DE115ACE19@gmail.com>
MIME-Version: 1.0 (Apple Message framework v1283)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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!