thank you, this makes sense.
On Thu, Jul 29, 2010 at 11:29 PM, Dan Nelson <[email protected]> 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.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?
>
> Your url may be the empty string "". If it was really NULL, you would see
> "NULL" in the resultset. Try
>
> SELECT * FROM product WHERE url=""
>
> --
> Dan Nelson
> [email protected]
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[email protected]
>
>
--
˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝs noʎ 'ʇuǝɯɐן sǝɯıʇ ǝɥʇ puɐ 'ʇuǝʇuoɔ
ǝq s,ʇǝן ʇǝʎ
%>>> "".join( [ {'*':'@','^':'.'}.get(c,None) or
chr(97+(ord(c)-83)%26) for c in ",adym,*)&uzq^zqf" ] )
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
