ido de Souza Neto [mailto:j...@consultorweb.cnt.br]
Enviado el: martes, 26 de abril de 2011 15:02
Para: mysql@lists.mysql.com
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
"&quo
'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 so
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 a
thank you, this makes sense.
On Thu, Jul 29, 2010 at 11:29 PM, Dan Nelson wrote:
> In the last episode (Jul 29), Norman Khine said:
>> I don't know what I am missing, but I have this:
>>
>> mysql> SELECT url FROM product WHERE url IS NULL;
>> Empty set (0.0
In the last episode (Jul 29), Norman Khine said:
> I don't know what I am missing, but I have this:
>
> mysql> SELECT url FROM product WHERE url IS NULL;
> Empty set (0.05 sec)
>
> mysql> SELECT url FROM product WHERE product_Id = 67;
> +--+
> | url |
&
what I am missing, but I have this:
mysql> SELECT url FROM product WHERE url IS NULL;
Empty set (0.05 sec)
mysql> SELECT url FROM product WHERE product_Id = 67;
+--+
| url |
+--+
| |
+--+
1 row in set (0.00 sec)
what goes with this, how can i ensure that this is NULL?
he
Hello,
I don't know what I am missing, but I have this:
mysql> SELECT url FROM product WHERE url IS NULL;
Empty set (0.05 sec)
mysql> SELECT url FROM product WHERE product_Id = 67;
+--+
| url |
+--+
| |
+--+
1 row in set (0.00 sec)
what goes with this, how can i
On Tue, May 09, 2006 at 12:13:41PM -0400, Rhino wrote:
>
> - Original Message -
> From: "Mohammed Sameer" <[EMAIL PROTECTED]>
> To:
> Sent: Tuesday, May 09, 2006 9:56 AM
> Subject: Order by leads to an empty set.
>
>
> >Hi all,
>
- Original Message -
From: "Mohammed Sameer" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, May 09, 2006 9:56 AM
Subject: Order by leads to an empty set.
Hi all,
I have a strange problem and I can't really understand what's going on!
mysql> SELECT n.nid, n.
Hi all,
I have a strange problem and I can't really understand what's going on!
mysql> SELECT n.nid, n.sticky, n.created FROM node n WHERE n.type='image' AND
(n.uid = 1 OR n.status = 1) ORDER BY n.created desc;
Empty set (0.00 sec)
mysql> SELECT n.nid, n.sticky, n
|
| Fax to:
|
| Subject: Unexpected behaviour: SELECT with OR returns empty set
|
>---
I am not sure what you are trying to do.
Do you want a join, or a union.
Your query is neither, and the results are correct as written.
Dave Gibson wrote:
Hi,
I'm getting some unexpected behaviour from a query and was
hoping someone could shed some light on whether it's a user
error or something el
Hi,
I'm getting some unexpected behaviour from a query and was
hoping someone could shed some light on whether it's a user
error or something else.
I have two tables:
customers, oems which both have a companyID field (marked
as a foreign key).
When I do:
SELECT * FROM customers WHERE customers.c
Hi
Im running mysql 4.0.12-embedded, a simple query - 'show proceslist'; returns an
empty set ? Is this a bug ?
thx
G
Maybe
if (!($result)) {
Try
print STDERR "RESULT=$result\n";
to see what you are comparing to.
Chris Hohimer wrote:
> thanks for all the replies!! but it is not working.
> here is the loop:
>
> if($result == EMPTY SET){
> $Scheduled = NULL;
> }
> else{
>
thanks for all the replies!! but it is not working.
here is the loop:
if($result == EMPTY SET){
$Scheduled = NULL;
}
else{
$Tech = mysql_result($result, 0, "tech");
$SNumber = mysql_result($result, 0, "snumber");
$Scheduled = mysql_result($r
- Original Message -
From: "Chris Hohimer" <[EMAIL PROTECTED]>
To: "Anil Garg" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 2:26 PM
Subject: Re: help with empty set
> yeah that kinda works...
>
> what i have
yeah that kinda works...
what i have is
$result = mysql($database "select x, y, z from $table where a and b and
c;", $link);
if ($result == empty set){
$z = NULL;
}
else
$x = mysql_result($result, 0, "x");
$y= mysql_result($result, 0, "y&quo
have u tried with \0 ??
- Original Message -
From: "Chris Hohimer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 1:54 PM
Subject: help with empty set
> using PHP what is the value for a returned result from MySQL of "empty
>
using PHP what is the value for a returned result from MySQL of "empty
set"
ex:
if($result != NULL){
do this
}
else{
do that
}
but NULL is not right. what should I replace NULL with?
-
Before posti
Sorry,
I failed the obligitory full-read of the mysql manual page ..
One question answered:
Default sort order is descending score .. my bad.
-Jay J
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
this:
---
SELECT id, body, MATCH (title,body) AGAINST ('Security implications of
running MySQL as root') AS score FROM articles WHERE MATCH (title,body)
AGAINST ('Security implications of running MySQL as root') ORDER BY
score;
Empty set (0.00 sec)
---
Is th
fic ip address that's in the "source_ip"
> > field. I can see that the record is there when I query all of the
> > records, but when I query for one specific ip, I get the empty set
> > result! :(
> >
> > Here is my query
> >
> > select
etc. I am trying to
> query the table for a specific ip address that's in the "source_ip"
> field. I can see that the record is there when I query all of the
> records, but when I query for one specific ip, I get the empty set
> result! :(
>
> Here is my
ame, etc. I am trying to
query the table for a specific ip address that's in the "source_ip"
field. I can see that the record is there when I query all of the
records, but when I query for one specific ip, I get the empty set
result! :(
Here is my query
select * from IDReport wh
25 matches
Mail list logo
