For this,
2012/10/04 16:13 +0200, MAS!
IF(GROUP_CONCAT(DISTINCT secA.sec_code SEPARATOR '|') is null,
IF(GROUP_CONCAT(DISTINCT secB.sec_code SEPARATOR '|') is null,
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 |
Hrm, what version of MySQL? I just ran the query on 5.5.24 and it worked as
expected.
- Derek Downey
On Oct 4, 2012, at 9:52 AM, MAS! wrote:
Hi
I know there'd be a reason, but I can't understand that..
mysql select @valore:=rand(), @valore, @valore:=ciao, @valore;
On 04/10/2012 15:52, MAS! wrote:
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
favore non alterare o perturbare la
comunicazione
From: urk...@gmail.com
Subject: (real) silly question about variables...
Date: Thu, 4 Oct 2012 15:52:20 +0200
To: mysql@lists.mysql.com
Hi
I know there'd be a reason, but I can't understand that..
mysql select @valore:=rand(), @valore
what version of MySQL are you running? I get this:-
mysql select version();
+---+
| version() |
+---+
| 5.1.63-0+squeeze1 |
+---+
I'm asking that because I have a trouble with a select..
I have something similar..
SELECT