# demo-mybatis-plus

**Repository Path**: pine_liu/demo-mybatis-plus

## Basic Information

- **Project Name**: demo-mybatis-plus
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-04-15
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 数据库
## 1.创建数据库
create schema mybatis_plus collate utf8_general_ci;
## 2.创建表

create table user
(
    id         bigint auto_increment primary key comment '主键',
    name       varchar(200) null,
    age        int comment '年龄',
    email      varchar(255),
    manager_id bigint comment '支书上级',
    create_time datetime comment '创建时间',
    -- 创建外键约束
    constraint fk_mybatis_plus_manager_id foreign key (
                                                       manager_id
        ) references user (id)
) charset = utf8;

## 3.插入数据
-- truncate table user;
insert into user(name, age, email, manager_id,create_time)
values
       ('duan1',11,'duan1@163.com',null,'2020/03/19 21:00'),
       ('duan2',12,'duan2@163.com',1,'2020/03/19 22:00'),
       ('duan3',13,'duan3@163.com',1,'2020/03/19 23:00'),
       ('duan4',14,'duan4@163.com',2,'2020/03/19 1:00'),
       ('duan5',15,'duan5@163.com',2,'2020/03/19 2:00');
## 3.查询数据
select * from user;