mysql根据条件查询单条数据_mysql 查询当某一条件满足时 的那一条数据

-- 每日代码行数记录表

create table code_line_record(

id_ int primary key auto_increment,

name varchar(20),

create_time_ date,

line_number_ int

);

insert into code_line_record values(null, "qiaolin", "2018-03-01", 100);

insert into code_line_record values(null, "qiaolin", "2018-03-02", 200);

insert into code_line_record values(null, "qiaolin", "2018-03-03", 300);

insert into code_line_record values(null, "qiaolin", "2018-03-04", 400);

insert into code_line_record values(null, "qiaolin", "2018-03-05", 500);

insert into code_line_record values(null, "qiaolin", "2018-03-06", 600);

insert into code_line_record values(null, "qiaolin", "2018-03-07", 700);

insert into code_line_record values(null, "qiaolin", "2018-03-08", 800);

insert into code_line_record values(null, "qiaolin", "2018-03-09", 900);

insert into code_line_record values(null, "qiaolin", "2018-03-10", 1000);