继续,写出实际的SQL语句
时间: 2024-03-21 11:41:04 浏览: 19
好的,以下是一些示例SQL语句,用于对数据库进行增、删、改、查操作:
1. 新增一个学生记录:
```
INSERT INTO Student (Name, Gender, Department, Grade, Class, DormitoryID)
VALUES ('张三', '男', '计算机科学与技术', '2018', '1班', '1010101');
```
2. 删除一个学生记录:
```
DELETE FROM Student WHERE ID = '1001';
```
3. 修改一个学生记录:
```
UPDATE Student SET Name = '李四', Gender = '女', Class = '2班' WHERE ID = '1002';
```
4. 查询学生住宿信息:
```
SELECT s.ID, s.Name, d.DormitoryID, a.ApartmentID
FROM Student s
INNER JOIN CheckIn c ON s.ID = c.StudentID
INNER JOIN Dormitory d ON c.DormitoryID = d.ID
INNER JOIN Apartment a ON d.ApartmentID = a.ID
WHERE s.Name = '张三';
```
5. 查询某个寝室内的学生信息:
```
SELECT s.ID, s.Name, s.Gender, s.Department, s.Grade, s.Class
FROM Student s
INNER JOIN CheckIn c ON s.ID = c.StudentID
INNER JOIN Dormitory d ON c.DormitoryID = d.ID
WHERE d.DormitoryID = '1010101';
```
6. 查询某个学生的出入记录:
```
SELECT c.CheckInOutID, c.CheckInOutDate, c.GoodsNum, c.VisitorName
FROM CheckInOut c
INNER JOIN Student s ON c.StudentID = s.ID
WHERE s.Name = '张三';
```
注意:以上SQL语句仅为示例,实际开发中需要根据具体需求进行修改和优化。同时,需要注意SQL注入等安全问题。
相关推荐
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![-](https://csdnimg.cn/download_wenku/file_type_column_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)