常用的数据
mybatis_test
CREATE TABLE `mybatis_test`.`user`(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`username` VARCHAR(120) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`password` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`gender` VARCHAR(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`email` VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`province` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`city` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`birthday` DATE DEFAULT NULL,
PRIMARY KEY(`id`)
) ENGINE = InnoDB CHARSET = utf8 COLLATE utf8_bin;
posted on 2018-08-02 18:28 Indian_Mysore 阅读(91) 评论(0) 编辑 收藏 举报