SELECT errors out saying a column doesn't exist that SHOW COLUMNS thinks does exist When I do "SELECT port, behavior FROM ip_addresses", I get an error
1054: Unknown column 'port' in 'field list'.
Doing a "SHOW COLUMNS FROM ip_addresses", however, shows that I *do*
in fact have a column 'port'. Here's the exact output I get:
Array
(
[Field] => ip_address
[Type] => varchar(8)
[Null] =>
[Key] => PRI
[Default] =>
[Extra] =>
)
Array
(
[Field] => behavior
[Type] => tinyint(2)
[Null] =>
[Key] =>
[Default] => 0
[Extra] =>
)
Array
(
[Field] => port
[Type] => varchar(4)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
Array
(
[Field] => last_checked
[Type] => int(11)
[Null] =>
[Key] =>
[Default] => 0
[Extra] =>
)
So why is MySQL simultaneously telling me that 'port' is a column and
isn't? And what can I do to fix it?
If it matters, the MySQL server in question is running on
ipowerweb.com. |