MySQL database-error 1166 Incorrect column name

MySQL database-error 1166 Incorrect column name indicates the field name, which contains spaces. You only need to use alert or phpmyadmin to modify the field.

The following error is reported when Navicat for MySQL is used to modify the table fields of the MySQL database.

SQL query:

Create table 'gfan _ content'. 'Channel _ '(
'Time' INT (11) not null comment' product id ',
'Bid' INT (11) not null comment 'Channel provider id'
) ENGINE = myisam character set utf8 COLLATE utf8_general_ci;

MySQL returns:

MySQL reports: #1166-Incorrect column name 'xxx'

Solution: Check whether there is any space in the field. Remove it.