mysql column name_我如何避免得到这个MySQL错误列COLUMN NAME列错误列表？

如何避免得到这个

MySQL错误列topicName列错误的列说明符？

MySQL错误…

#1063 - Incorrect column specifier for column 'topic_id'

SQL模式…

CREATE TABLE discussion_topics (

topic_id char(36) NOT NULL AUTO_INCREMENT,

project_id char(36) NOT NULL,

topic_subject VARCHAR(255) NOT NULL,

topic_content TEXT default NULL,

date_created DATETIME NOT NULL,

date_last_post DATETIME NOT NULL,

created_by_user_id char(36) NOT NULL,

last_post_user_id char(36) NOT NULL,

posts_count char(36) default NULL,

PRIMARY KEY (topic_id)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;