Skip navigation links

MySQL Forums :: Perl :: Select query returns false result.


Advanced Search

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. Tom Thomas 02/03/2013 11:20PM
Re: Select query returns false result. Rick James 02/04/2013 09:03PM


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.