[SQL] CREATE TABLE user(

'uid' int(10) AUTO_INCREMENT PRIMARY KEY COMMENT '用户ID',

'username' varchar(30) NOT NULL DEFAULT '' COMMENT '用户名',

'password' char(6) NOT NULL DEFAULT '' COMMENT '密码',

'sex' char(2) NOT NULL DEFAULT '保密' COMMENT '性别',

'email' varchar(40) NOT NULL DEFAULT '' COMMENT '邮箱',

'hobby' varchar(255) NOT NULL DEFAULT '' COMMENT '兴趣爱好',

KEY 'username'('username')

)ENGINE=MyISAM DEFAULT CHARSET=UTF8 COMMENT='用户表';

[Err] 1064 - 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 ''uid' int(10) AUTO_INCREMENT PRIMARY KEY COMMENT '用户ID',

'username' varch' at line 3

这是我看笔记创建的数据表  为什么会这样  报错求解