查询

`mytest`
SELECT  * FROM
student;
SELECT 学号,姓名,性别
FROM student;
SELECT * FROM student
WHERE 性别='女';
SELECT * FROM student
WHERE 毕业学校 LIKE '%乌鲁木齐%';-- %代表多的或零个字符
SELECT 姓名,性别,出生日期,YEAR(NOW())- YEAR(出生日期) AS 年龄  FROM student
 WHERE YEAR(NOW())- YEAR(出生日期) IN(17,18);
 SELECT 姓名,性别,出生日期,YEAR(NOW())- YEAR(出生日期) AS 年龄  FROM student
 WHERE 17< YEAR(NOW())- YEAR(出生日期) <18;
  SELECT 姓名,性别,出生日期,YEAR(NOW())- YEAR(出生日期) AS 年龄  FROM student
 WHERE YEAR(NOW())- YEAR(出生日期) >18;