Error 1064 help!

I am getting this error. Can someone please tell me what I am doing wrong?

mysql> CREATE TABLE hoist (
-> id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> manufacturer TEXT,
-> serial number TEXT,
-> ) DEFAULT CHARACTER SET utf8;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MYSQL server version for the right syntax to use near 'number TEXT,
) DEFAULT CHARACTER SET utf*' at line 4
mysql>

I am using MY SQL 5.5

Thanks!!!!

 

Hi, column name must be a single word, so you can use serial_number. Please check documentation

 

Or you can use back ticks around the the column name like `serial number`