# mybatis-plus-helper-demo **Repository Path**: hanscoding/mybatis-plus-helper-demo ## Basic Information - **Project Name**: mybatis-plus-helper-demo - **Description**: mybatis-plus-helper 代码测试 - **Primary Language**: Unknown - **License**: Not specified - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2021-12-10 - **Last Updated**: 2023-03-15 ## Categories & Tags **Categories**: Uncategorized **Tags**: mybatis-plus, Spring, SpringBoot ## README # mp扩展工具使用demo `https://gitee.com/hanscoding/mybatis-plus-helper` ## 项目所用sql语句 ```sql create table student ( id int auto_increment primary key, no varchar(6) not null comment '学号', name varchar(8) not null comment '姓名', birthday datetime null comment '生日', sex tinyint(1) not null comment '性别', create_time datetime null, update_time datetime null, constraint stu_info_no_uindex unique (no) ); create table subject_info ( id int auto_increment primary key, no varchar(4) not null comment '课程编号', name varchar(20) not null comment '课程名字', stu_no varchar(6) not null comment '学生编号', constraint subject_info_no_uindex unique (no) ) comment '课程信息'; create table score_info ( id int auto_increment primary key, stu_no varchar(6) not null comment '学生学号', subject_no varchar(4) not null comment '课程编号', score int(4) not null comment '分数', stu_score int(1) not null comment '学分', stu_time int(2) not null comment '学时', create_time datetime null, update_time datetime null, constraint score_info_stu_no_subject_no_uindex unique (stu_no, subject_no), constraint score_info_stu_info_no_fk foreign key (stu_no) references student (no), constraint score_info_subject_info_no_fk foreign key (subject_no) references subject_info (no) ) comment '成绩表'; ```