Thread: SELECT errors out saying a column doesn't exist that SHOW COLUMNS thinks does exist
View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 10:08 AM
Lee Peedin
 
Posts: n/a
Default Re: SELECT errors out saying a column doesn't exist that SHOW COLUMNS thinks does exist
On 9 Feb 2007 09:52:52 -0800, "yawnmoth" <terra1024@yahoo.com> wrote:

>When I do "SELECT port, behavior FROM ip_addresses", I get an error
>1054: Unknown column 'port' in 'field list'.
>

Try

"SELECT `port`, behavior FROM ip_addresses"

and see if that works - if so, MySQL is treating "port" as a "reserved
word".

Lee

Reply With Quote