Results 1 to 1 of 1
Thread: mysql empty set
- 04-25-2011, 03:01 PM #1
Member
- Join Date
- Apr 2011
- Posts
- 20
- Rep Power
- 0
mysql empty set
hi! I'm driving crazy!!
I have a java code which runs mysql. I have a huge query, that could return "empty set" if some value is not correct, what I want to do is insert in this value "something", maybe "void" or "0":
My database:
My "empty" consult:PHP Code:mysql> select * from usuarios; +-----------+--------+ | usuarioID | codigo | +-----------+--------+ | 1 | 456 | | 2 | 789 | | 3 | 123 | +-----------+--------+ 3 rows in set (0.00 sec)
What I want:PHP Code:mysql> SELECT usuarioID FROM usuarios WHERE codigo = 45; Empty set (0.00 sec)
Is it possible? thank you!!PHP Code:+-----------+ | usuarioID | +-----------+ | Void | +-----------+
Last edited by cucucur; 04-25-2011 at 03:03 PM.
Similar Threads
-
Empty Form?
By Vorfin in forum New To JavaReplies: 13Last Post: 07-04-2010, 11:54 PM -
Empty FileInputStream..
By dudejonne in forum New To JavaReplies: 5Last Post: 11-08-2009, 08:21 PM -
MySQL/JDBC Mysql query output
By thelinuxguy in forum Advanced JavaReplies: 4Last Post: 02-13-2009, 01:57 AM -
KeyBindings Empty Key?
By Unome in forum Java AppletsReplies: 1Last Post: 10-24-2008, 07:28 PM -
Empty ResultSet
By Java Tip in forum Java TipReplies: 0Last Post: 02-09-2008, 08:36 PM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks