View Single Post

   
  #4 (permalink)  
Old 02-28-2008, 10:08 AM
Rik
 
Posts: n/a
Default Re: SELECT errors out saying a column doesn't exist that SHOW COLUMNS thinks does exist

On Fri, 09 Feb 2007 21:44:37 +0100, yawnmoth <terra1024@yahoo.com> wrote:

> On Feb 9, 2:09 pm, Lee Peedin <lpeedinDONOTSP...@nc.rr.com> wrote:
>> On 9 Feb 2007 09:52:52 -0800, "yawnmoth" <terra1...@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

>
> Just tried it. Still get the same error
>


What does a SHOW CREATE TABLE `ip_adresses` show?

--
Rik Wasmus
Reply With Quote