Thank you so much!! It works!!
mysql> SELECT COUNT(*) usuarios,codigo FROM usuarios WHERE codigo = 45;
+----------+--------+
| usuarios | codigo |
+----------+--------+
| 0 | NULL |
+----------+--------+
1 row in set (0.00 sec)
-----Mensaje original-----
De: João Cândido de Souza Neto [mailto:[email protected]]
Enviado el: martes, 26 de abril de 2011 15:02
Para: [email protected]
Asunto: Re: empty set
As far as I know, it isn´t possible.
The right way is to check how many rows your select has returned.
--
João Cândido de Souza Neto
""Rocio Gomez Escribano"" <[email protected]> escreveu na
mensagem
news:000601cc03e2$fd3c9540$f7b5bfc0$@[email protected]...
> 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!!
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[email protected]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
