Re: SELECT errors out saying a column doesn't exist that SHOW COLUMNS thinks does exist On Feb 9, 3:04 pm, Rik <luiheidsgoe...@hotmail.com> wrote:
> <snip>
> What does a SHOW CREATE TABLE `ip_adresses` show?
[Table] => phpbb_proxies
[Create Table] => CREATE TABLE `ip_addresses` (
`ip_address` varchar(8) NOT NULL default '',
`behavior` tinyint(2) NOT NULL default '0',
`port ` varchar(4) default '0',
`last_checked` int(11) NOT NULL default '0',
PRIMARY KEY (`ip_address`)
) TYPE=MyISAM |