SQL Error(1166) : Incorrect column name 'id'

Question

I am new to yii and heidiSQL while am creating new table i get this error,so help me to solve this error

CREATE TABLE `users` (
    `id ` INT(45) NULL,
    `username ` VARCHAR(50) NULL,
    `pwd_hash` VARCHAR(50) NULL,
    `fname` VARCHAR(50) NULL,
    `lname` VARCHAR(50) NULL,
    `email` VARCHAR(50) NULL,
    `country` VARCHAR(50) NULL,
    `address` VARCHAR(50) NULL,
    `gender` VARCHAR(50) NULL,
    INDEX `PRIMARY KEY` (`id `),
    INDEX `UIQUE KEY` (`username `)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;

I can't able to create new table in database.

Answer 1

Spaces are not allowed at the end of column's definition, must be:

CREATE TABLE `users` (
    `id` INT(45) NULL,
    `username` VARCHAR(50) NULL,
    `pwd_hash` VARCHAR(50) NULL,
    `fname` VARCHAR(50) NULL,
    `lname` VARCHAR(50) NULL,
    `email` VARCHAR(50) NULL,
    `country` VARCHAR(50) NULL,
    `address` VARCHAR(50) NULL,
    `gender` VARCHAR(50) NULL,
    INDEX `PRIMARY KEY` (`id`),
    INDEX `UNIQUE KEY` (`username`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB

You have same error for username.