数据库基本查询练习

已极

已于 2022-05-14 09:39:03 修改

阅读量605

点赞数 1

文章标签：数据库 mysql sql

于 2022-05-14 09:37:02 首次发布

本文链接：https://blog.csdn.net/m0_66980155/article/details/124764071

版权

本文主要介绍了MySQL数据库的基础查询操作，包括如何选择表格中的特定数据、使用WHERE子句过滤记录、进行排序和分组等核心概念。通过实例解析，帮助读者掌握数据库查询的基本技巧。

摘要由CSDN通过智能技术生成

数据库表格基本查询

USE mydb;
-- 查询全部一年级学生chaxun
-- 关联查询
SELECT * FROM student s INNER JOIN grade g ON s.`gradeid` =g.`gradeid` WHERE gradename  = '一年级';

-- 查询二年级学生姓名和电话
SELECT gradeid FROM  grade WHERE gradename = '二年级' ;
SELECT studentname,phone FROM  student WHERE gradeid = (SELECT gradeid FROM  grade WHERE gradename = '二年级');
-- 关联查询
SELECT studentname,phone FROM student s INNER JOIN grade g ON s.`gradeid` =g.`gradeid` WHERE gradename  = '二年级';

-- 查询一年级女同学的信息
SELECT * FROM  student WHERE gradeid = (SELECT gradeid FROM  grade WHERE gradename = '一年级') AND sex = '女';         

-- 查询二年级的科目信息
SELECT gradeid FROM grade WHERE gradename = '二年级';
SELECT *FROM subjects WHERE gradeid =(SELECT gradeid FROM grade WHERE gradename = '二年级');
-- 关联查询
SELECT *FROM subjects s INNER JOIN grade g ON s.`gradeid` =g.`gradeid`  WHERE gradename ='二年级';   

-- 查询二年级男同学的姓名住址
SELECT studentname,address FROM student WHERE gradeid =(SELECT gradeid FROM grade WHERE gradename = '二年级') AND sex ='男';
-- 关联查询
SELECT studentname,address FROM student s INNER JOIN grade g ON s.`gradeid` =g.`gradeid`  WHERE gradename ='二年级&