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 askin
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:
C
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 con
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
http://www.designmagic
Original Message
Subject: Re: [PHP-DB] MySQL Conditional Trigger
From: Chris
To: OKi98
Date: 8.12.2008 23:09
anything compared to NULL is always false
Actually it's null.
mysql> select false = null;
+--+
| 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:
I tested this,
o:[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;
+--+
| false = null |
+--+
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 ro
Monday, December 08, 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 d
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 playi
10 matches
Mail list logo