where price=7.99; in the select caluse is not working
Posted by: fdgsdgfs sdgdsgds
Date: August 27, 2010 04:31PM

Hi,

I have been trying to use the following command in the mysql> command prompt like this:

mysql> select column1, column2 from TableA where price=7.99;

It gives me the following response:

Empty set <0.00 sec>

Is it possible the mysql doesn't have = operator, but it works with the char variables just like it does in SQL.
Please let me know what's going on here.

Thanks,

cK

Options: ReplyQuote


Subject
Written By
Posted
where price=7.99; in the select caluse is not working
August 27, 2010 04:31PM


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.