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;有错