Re: MySQL returns the same result using the IN clause irrespective of the value used
Posted by: Rick James
Date: July 17, 2015 03:49PM

Quote literals (using ' or ") when comparing to a VARCHAR.

792718488739137399 is too big for an INT, but not too big for a BIGINT.

792718488739137399, converted to FLOAT or DOUBLE, will lose some some precision and be indistinguishable from
792718488739137398.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL returns the same result using the IN clause irrespective of the value used
1130
July 17, 2015 03:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.