#1166 - Incorrect column name

Databases
1

Hey there everyone,

I’m trying to create a really simple table in phpmyadmin but I keep getting the following error:

#1166 - Incorrect column name 'companycredit_id ’

What the heck does this mean?

Here’s the SQL I’ve got:

CREATE TABLE `se_company_credit` (
      `companycredit_id ` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT         PRIMARY KEY ,
      `companycredit_credittype_id ` INT( 10 ) UNSIGNED NULL ,
      `companycredit_company_id ` INT( 10 ) UNSIGNED NULL ,
      `companycredit_expiry_date ` DATE NULL ,
      `companycredit_value ` DECIMAL( 10, 0 ) NULL ,
       INDEX ( `companycredit_credittype_id ` , `companycredit_company_id ` )
) ENGINE = innodb

Any help would be appreciated.

2

maybe it’s the extra space after the name causing trouble?

companycredit_credittype_id

3

Never mind… it was the spaces after the column names!

4

Thanks Robert! Yep!