DROP TABLE IF EXISTS t_signup_list;

CREATE TABLE t_signup_list (

    id int NOT NULL AUTO_INCREMENT ,

    create_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

    update_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',

    name varchar(255) NOT NULL COMMENT '姓名',

    qq bigint UNSIGNED NOT NULL COMMENT 'QQ',

    course varchar(255) NOT NULL COMMENT '修真类型',

    planned_date_of_entrance date NOT NULL COMMENT '预计入学日期',

    graduate_school varchar(255) DEFAULT NULL COMMENT '毕业院校',

    online_id int UNSIGNED NOT NULL COMMENT '线上学号',

    daily_url varchar(255) NOT NULL COMMENT '日报链接',

    desire varchar(255) NOT NULL COMMENT '立愿',

    senior varchar(255) NOT NULL COMMENT '师兄',

    PRIMARY KEY (id, online_id) USING BTREE

)   ENGINE = InnoDB   AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 collate =   utf8mb4_general_ci ROW_FORMAT = Dynamic;

insert into t_signup_list   (name, qq, course, planned_date_of_entrance, graduate_school, online_id,   daily_url, desire, senior) values ('段文凯', 764699493, 'Java', '2018-03-12', '中国矿业大学', 3396, 'http://www.jnshu.com/school/22490/daily', '立誓转行', '卢炳伸');

Affected rows: 1

select * from t_signup_list where name = '段文凯';

成功显示返回记录。