Re: MySQL Conditional Trigger

From: Date: Thu, 18 Dec 2008 22:04:28 +0000
Subject: Re: MySQL Conditional Trigger
References: 1 2 3  Groups: php.db 
Request: Send a blank email to php-db+get-45815@lists.php.net to get a copy of this message
-------- Original Message -------- Subject: Re: [PHP-DB] MySQL Conditional Trigger From: Chris <dmagick@gmail.com> To: OKi98 <oki98@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 | +--------------+
|         NULL |
+--------------+ 1 row in set (0.01 sec) mysql> select 1 = null; +----------+ | 1 = null | +----------+
|     NULL |
+----------+ 1 row in set (0.00 sec) mysql> select 2 = null; +----------+ | 2 = null | +----------+
|     NULL |
+----------+ 1 row in set (0.00 sec) unknown compared to anything is unknown. he was talking about plsql and condition evaluation (ends with true or false), your point is absolutely useless.


« previous php.db (#45815) next »