MySQL Forums
Forum List  »  Perl

Select query returns false result.
Posted by: Tom Thomas
Date: February 03, 2013 11:20PM

eg:

Table : user
column : user_id (type is int)

SELECT * FROM user WHERE user_id = '10xyz' is giving same result of
SELECT * FROM user WHERE user_id = '10'


The input value is not integer but not giving an error in this case.

Options: ReplyQuote


Subject
Written By
Posted
Select query returns false result.
February 03, 2013 11:20PM


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.