Sql Syntax Error [corrected] - apostrophes missing
Discussion by Eggie with 2 Replies.
Last Update: February 18, 2008, 10:15 am
QUOTE#1054 - Unknown column 'Eggie' in 'where clause'
i get that error when i type this in MYSQL
CODEselect bike from members where username=Eggie
i have column bike,members and username...
and i have information in every of those columns...
but why does it say that there is no COLUMN because i said i want info from row where column 'username' is 'Eggie'
btw-YAY..my 101 post
EDIT:sorry...i just solved it i forgot to put apostrophes
CODEselect bike from members where username='Eggie'
Well, this is always something a lot of ppl miss easily. Because the error "Unknown column" is quite misleading in this case. Anyway, it's good that you found out yourself.
QUOTEsorry...i just solved it i forgot to put apostrophes
congrats for the self-repairing. I slightly touched the topic title in order to make it reflect the facts.
|Apache Php With Mysql On Windows [solved] (9)||(4) Not Understanding Mysql|