MySQL database Error 1166 Incorrect column name

MySQL database - error 1166 Incorrect column name field name. This is a field with a space in it. This one can be modified using alert or phpmyadmin.

The following error occurred today when modifying table fields to the MySQL database using Navicat for MySQL

SQL query:

CREATE TABLE `gfan_content`.`channel_into` ( 
`time` INT( 11 ) NOT NULL COMMENT ' product id', 
`bid` INT( 11 ) NOT NULL COMMENT ' distributors id' 
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci; //ofstack.com

MySQL returns:

All right? All right? Incorrect column 'xxx'

mysql-error-1166

To solve the problem, check whether there is a space in the field and remove it.