Aleksandar Vojnovic wrote:
You could try with the operator.
!=, Not equal operator
Same issue as using '=':
mysql select 2 null;
+---+
| 2 null |
+---+
| NULL |
+---+
1 row in set (0.00 sec)
Comparing anything with null returns null. (I'm not asking for a
You could try with the operator.
!=, Not equal operator
Or you could try it this way - ISNULL(col_or_data_to_check).
Example:
mysql SELECT ISNULL(1+1);
+-+
| ISNULL(1+1) |
+-+
| 0 |
+-+
1 row in set (0.02 sec)
Aleksander
Chris wrote:
Chris
Original Message
Subject: Re: [PHP-DB] MySQL Conditional Trigger
From: Chris dmag...@gmail.com
To: OKi98 ok...@centrum.cz
Date: 8.12.2008 23:09
anything compared to NULL is always false
Actually it's null.
mysql select false = null;
+--+
| false = null
unknown compared to anything is unknown.
he was talking about plsql and condition evaluation (ends with true or
false), your point is absolutely useless.
The context is in the database - my example is in the database. How is
that useless?
--
Postgresql php tutorials
Chris wrote:
unknown compared to anything is unknown.
he was talking about plsql and condition evaluation (ends with true or
false), your point is absolutely useless.
The context is in the database - my example is in the database. How is
that useless?
In case you missed it, this is the
Original Message
Subject: [PHP-DB] MySQL Conditional Trigger
From: Dee Ayy [EMAIL PROTECTED]
To: php-db@lists.php.net
Date: 31.10.2008 17:09
I don't think my trigger likes a comparison with a variable which is
NULL. The docs seem to have a few interesting variations on
, 2008 4:33 PM
To: Dee Ayy
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] MySQL Conditional Trigger
Original Message
Subject: [PHP-DB] MySQL Conditional Trigger
From: Dee Ayy [EMAIL PROTECTED]
To: php-db@lists.php.net
Date: 31.10.2008 17:09
I don't think my trigger likes
anything compared to NULL is always false
Actually it's null.
mysql select false = null;
+--+
| false = null |
+--+
| NULL |
+--+
1 row in set (0.01 sec)
mysql select 1 = null;
+--+
| 1 = null |
+--+
| NULL |
+--+
1 row
.
Be Well,
A-
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2008 5:10 PM
To: OKi98
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] MySQL Conditional Trigger
anything compared to NULL is always false
Actually it's null.
mysql select false = null
Fortuno, Adam wrote:
All,
Chris makes a good point i.e., unknown compared to anything is
unknown. His comment made me want to clarify my earlier note. In my
earlier example, I wasn't suggesting that-that logic be coded in the
database. I was assuming it would be in the page:
?php
10 matches
Mail list logo