Can u tell me , assume if i use If in the query , then i reduce performance
,
Any idea
On Mon, May 18, 2009 at 3:19 PM, Janek Bogucki
wrote:
> Hi,
>
> mysql> create table t(i int);
>
> mysql> insert into t values(1),(2),(3);
>
> mysql> select i, if(i <= 1, 'low', 'high') from t order by i;
> +--
Hi,
mysql> create table t(i int);
mysql> insert into t values(1),(2),(3);
mysql> select i, if(i <= 1, 'low', 'high') from t order by i;
+--+---+
| i| if(i <= 1, 'low', 'high') |
+--+---+
|1 | low |
|2 | hig
Hi all ,
Can u give one example query ,
Which contain the IF condition ,
Because here before am not used the IF and all ,
Thanks
--
உங்கள் நண்பன்
பரணி குமார்
Regards
B.S.Bharanikumar
POST YOUR OPINION
http://bharanikumariyerphp.site88.net/bharanikumar/