CREATE TABLE `imooc_goddess` (

  `id` int primary key auto_INCREMENT,

  `user_name` varchar(30) NOT NULL,

  `sex` int,

  `age` int,

  `birthday` date,

  `email` varchar(30),

  `mobile` varchar(11),

  `create_user` varchar(30),

  `create_date` date,

  `update_user` varchar(30),

  `update_date` date,

  `isdel` int

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

alter database jdbc default character set 'utf8';

SET character_set_client='utf8';

SET character_set_connection='utf8';

SET character_set_results='utf8';