List:General Discussion« Previous MessageNext Message »
From:João Cândido de Souza Neto Date:April 26 2011 1:01pm
Subject:Re: empty set
View as plain text  
The right way is to check how many rows your select has returned.

-- 

""Rocio Gomez Escribano"" <r.gomez@stripped> escreveu na 
mensagem 
news:000601cc03e2$fd3c9540$f7b5bfc0$@gomez@ style="color:#666">stripped...
> Hi!  I'm not sure it would be possible what I want to.
>
>
>
> I have a huge query, most of them are independent, and they could have not
> answer. What I want is when this happen, I want to change the "empty set" 
> by
> "void" or "0" or something like that, here it is an example:
>
>
>
> mysql> select * from usuarios;
> +-----------+--------+
> | usuarioID | codigo |
> +-----------+--------+
> |         1 |    456 |
> |         2 |    789 |
> |         3 |    123 |
> +-----------+--------+
> 3 rows in set (0.00 sec)
>
>
>
> mysql> SELECT usuarioID FROM usuarios WHERE codigo = 45;
> Empty set (0.00 sec)
>
>
>
>
>
> +-----------+
> | usuarioID |
> +-----------+
> |      Void |
> +-----------+
>
>
>
> Is it possible???
>
>
>
> Thank you!!
>
> 


Thread
empty setRocio Gomez Escribano26 Apr
  • Re: empty setjoao26 Apr
    • RE: empty setRocio Gomez Escribano26 Apr