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 nul
> 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 @sec:=IF(GROUP_C
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.
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" | @val
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;
> +
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 |
+---+-
