mysql> CREATE TABLE imooc_goddess (

? id int(11) PRIMARY KEY AUTO_INCREMENT,

? user_name varchar(30) NOT NULL,

? sex int(11) DEFAULT NULL,

? age int(11) DEFAULT NULL,

? birthday date DEFAULT NULL,

? email varchar(30) DEFAULT NULL,

? mobile varchar(11) DEFAULT NULL,

? create_user varchar(30) DEFAULT NULL,

? create_date date DEFAULT NULL,

? update_user varchar(30) DEFAULT NULL,

? update_date date DEFAULT NULL,

? isdel int(11) DEFAULT NULL,

)engine=innodb default charset=utf8 auto_increment=1;

alter database imooc DEFAULT CHARACTER SET 'utf8';

SET character_set_client='utf8';

SET character_set_connection='utf8';

SET character_set_results='utf8';

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 ')engine=innodb default charset=utf8 auto_increment=1' at line 14

Query OK, 1 row affected

Query OK, 0 rows affected

Query OK, 0 rows affected

Query OK, 0 rows affected

為什么一直說這個)engine=innodb default charset=utf8 auto_increment=1;有錯