<update id="updateStudentState">
UPDATE te_signin_details sd
LEFT JOIN te_sign_in si ON sd.sign_in_id = si.id
SET
sd.state = #{state}
WHERE
sd.is_delete = 0
AND si.is_delete = 0
AND si.state = '0'
AND sd.student_id = #{studentId}
</update>
```
哈哈哈哈
最新推荐文章于 2022-09-17 10:40:09 发布