Mysql user defined variable

Mysql user defined variable

El Forum
Guest

04-26-2011, 01:54 PM

[eluser]dannythebestguy[/eluser]
Nick,

Select @var gives a null value.
Select @var := col1 - col2 FROM table1 WHERE col3 = @var gives result as expected from any client, but with CI it does returns a empty array. It does not complain of wrong SQL or throws any error.

Messages In This Thread

Mysql user defined variable - by El Forum - 04-25-2011, 10:01 PM

Mysql user defined variable - by El Forum - 04-25-2011, 10:33 PM

Mysql user defined variable - by El Forum - 04-25-2011, 10:36 PM

Mysql user defined variable - by El Forum - 04-26-2011, 01:11 PM

Mysql user defined variable - by El Forum - 04-26-2011, 01:54 PM

Mysql user defined variable - by El Forum - 04-26-2011, 02:03 PM

Mysql user defined variable - by El Forum - 04-26-2011, 03:17 PM

Mysql user defined variable - by El Forum - 04-26-2011, 03:21 PM