List:General Discussion« Previous MessageNext Message »
From:Prathima Rao Date:March 15 2011 4:09pm
Subject:Re: "IF"
View as plain text  
Is there a field to save symbols like degree in mysql
------Original Message------
From: Peter Brawley
To: mysql@stripped
ReplyTo: peter.brawley@stripped
Subject: Re: "IF"
Sent: Mar 15, 2011 9:22 PM

>  Yes, but Access s "IIF", of the same use, evaluates all three, and the documentation explicitly says so.

Let's be glad we don't depend on Access, then.

PB

-----

On 3/14/2011 7:52 PM, Sándor Halász wrote:
>>>>> 2011/03/14 16:08 +0100, Johan De Meersman>>>>
> I'm afraid I'm not authoritative on this, but it seems to me that it would be very very bad if the third, unused expression were to be evaluated - not only from a performance point of view, but who is to say that that expression is not a user-defined function that modifies the database ?
> <<<<<<<<
> Yes, but Access s "IIF", of the same use, evaluates all three, and the documentation explicitly says so. MySQL s, that I have seen, says neither. Assuming the worst is safer, and then one uses CASE ..., but if not, ....
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=prathimanrao@stripped



Prathima Rao  blackberry mail
Thread
"IF"hsv14 Mar
  • Re: "IF"Johan De Meersman14 Mar
    • Re: "IF"hsv15 Mar
      • Re: "IF"Peter Brawley15 Mar
      • Re: "IF"Johan De Meersman15 Mar
      • RE: "IF"Jerry Schwartz15 Mar
Re: "IF"Prathima Rao15 Mar