mysql实现复杂的UPDATE语句(子查询)

最新推荐文章于 2024-12-02 00:15:00 发布

原创最新推荐文章于 2024-12-02 00:15:00 发布 · 3.9k 阅读

2 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

21 篇文章

订阅专栏

本文介绍了一种使用SQL语句来更新学生课程状态的方法。通过内连接查询，精确地定位到特定教师ID下，除了个别学生外的所有学生，在周六19:45至20:25时间段内的课程状态，并将其从激活状态更改为停用状态，同时更新修改时间。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

update student_continue_intervals sc,(SELECT sci.STUDENT_ID,sci.WEEK_DAY,sci.`START`,sci.`END` from student s
INNER JOIN ts_relationship tsr ON s.ID = tsr.STUDENT_ID AND tsr.R_TYPE = 0
INNER JOIN student_continue_intervals sci ON s.ID = sci.STUDENT_ID AND sci.WEEK_DAY = 6 AND sci.`START` = '19:45' AND sci.`END` = '20:25' AND sci.STATE = 1
WHERE  tsr.TEACHER_ID = '2031d289-0863-11e7-9b52-0242c0a81004' AND s.ID <> '8d57066f-db50-11e8-9bc2-5cb901893df8') AS sd set sc.STATE = 0,sc.MODIFIED_TIME=NOW() 
WHERE sc.STUDENT_ID = sd.STUDENT_ID AND sc.WEEK_DAY = sd.WEEK_DAY AND sc.`START` = sd.`START` AND sc.`END` = sd.`END` AND sc.STATE = 1