MySQL Forums
Forum List  »  Newbie

Select statement help
Posted by: Nate Balk
Date: November 24, 2004 03:40PM

I am very new to this, and i am trying to do what i thought would be a very easy query. What I want to do is this

Select * FROM 30yr
WHERE key=1;

key is a valid column name and my primary key and 30yr is a valid table.

If I do

Select * FROM 30yr
WHERE intrate=5.740;

I am successful, which is what should show up when i do WHERE key=1; can I not use a where statement on my primary key?

Options: ReplyQuote


Subject
Written By
Posted
Select statement help
November 24, 2004 03:40PM
November 24, 2004 04:41PM
November 29, 2004 11:28AM


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.