Is there a field to save symbols like degree in mysql ------Original Message------ From: Peter Brawley To: mysql@lists.mysql.com ReplyTo: peter.braw...@earthlink.net 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=prathiman...@vsnl.net Prathima Rao blackberry mail
