mysql> create table imooc_goddess(

id int primary key auto_imcrement,

user_name varchar(30) not null,

sex int,

age int,

birthday date,

emailvarchar(30),

mobile varchar(11),

create_user varchar(30),

update_date date,

isdel int

)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 'auto_imcrement,

user_name varchar(30) not null,

sex int,

age int,

birthd' at line 2

Query OK, 1 row affected

Query OK, 0 rows affected

Query OK, 0 rows affected

Query OK, 0 rows affected

mysql>