MySQL数据库查找

select（查找）——内容——from——表名——where——查找条件；

例如：

create table students(
    student_id INT  UNSIGNED,
    name VARCHAR(30),
    sex CHAR(1),
    birth DATE,
    PRIMARY KEY (student_id));

    insert into students(student_id,name,sex,birth)
    values(410048101,'lucy green','1','1990-002-14');

    select*from students;

+----------------+---------------+-----+----------------+
| student_id    | name        | sex | birth            |
+----------------+---------------+-----+----------------+
|  410048101 | lucy green | 1    | 1990-02-14 |
+----------------+---------------+-----+----------------+

    select name from students where student_id=410048101;

    +------------+
   | name       |
   +------------+
   | lucy green |
   +------------+