Hi Jerry, all!
Jerry Schwartz wrote:
>> [[...]]
>>
>> Maybe:
>>
>> WHERE coalesce(x, 17) = 17
>>
>>
> [JS] Interesting suggestion, but
>
> us-gii >select benchmark(1000,(7=7 or null is null));
> [[...]]
> 1 row in set (0.34 sec)
>
> us-gii >select benchmark(1,coalesce(null,7));
> [[
1
www.the-infoshop.com
>-Original Message-
>From: João Cândido de Souza Neto [mailto:j...@consultorweb.cnt.br]
>Sent: Wednesday, March 10, 2010 2:10 PM
>To: mysql@lists.mysql.com
>Subject: Re: Particular value or NULL
>
>Did you gave a try on using coalesce in your query?
>
Maybe:
WHERE coalesce(x, 17) = 17
[JS] Interesting suggestion, but
us-gii >select benchmark(1000,(7=7 or null is null));
+---+
| benchmark(1000,(7=7 or null is null)) |
+---+
|
y, March 10, 2010 10:55 AM
>>To: mysql@lists.mysql.com
>>Subject: Re: Particular value or NULL
>>
>>Maybe:
>>
>>WHERE coalesce(x, 17) = 17
>>
>>
> [JS] Interesting suggestion, but
>
> us-gii >select benchmark(1000,(7=7 or null is n
>-Original Message-
>From: João Cândido de Souza Neto [mailto:j...@consultorweb.cnt.br]
>Sent: Wednesday, March 10, 2010 10:55 AM
>To: mysql@lists.mysql.com
>Subject: Re: Particular value or NULL
>
>Maybe:
>
>WHERE coalesce(x, 17) = 17
>
>
[JS] Interestin
Maybe:
WHERE coalesce(x, 17) = 17
""Jerry Schwartz"" escreveu na mensagem
news:023301cac069$366afa00$a340ee...@com...
> Is there a better construct for the WHERE clause in a LEFT JOIN than
>
>
>
> WHERE (x = 17 OR x IS NULL)
>
>
>
> ?
>
>
>
> Regards,
>
>
>
> Jerry Schwartz
>
> The Infoshop by