更新teaching中fdSubjectID为null的老数据
2024-09-10 21:29:20
UPDATE wkwke.tbTeachingV3 teaching SET teaching.fdSubjectID = (
SELECT fdValue FROM
(SELECT teaching1.id, subtype.fdValue
FROM wkwke.tbTeachingV3 teaching1
LEFT JOIN wkctn.tbContent content
ON teaching1.fdPrepareID=content.id
LEFT JOIN wkctn.tbInteger subtype
ON subtype.fdContentID = content.id
WHERE subtype.fdAttributeID = 36
) newSubject WHERE newSubject.id = teaching.id
)
update wkwke.tbTeachingV3 teaching left join wkctn.tbContent prepares on prepares.id = teaching.fdPrepareID left join wkctn.tbInteger subject on subject.fdAttributeID = 36 and subject.fdContentID =
prepares.id set teaching.fdSubjectID = subject.fdValue
更新班测记录
UPDATE wkwke.tbScanExam scan LEFT JOIN wkwke.tbExam exam ON exam.id = scan.fdExamID LEFT JOIN wkctn.tbContent content ON content.id = exam.fdContentID LEFT JOIN wkctn.tbInteger subject ON subject.fdAttributeID = 36 AND subject.fdContentID = content.id SET scan.fdSubjectID = subject.fdValue
更新没有属性的学科年级组长
UPDATE `tbPositionUserMap` usermap
LEFT JOIN `tbPositionUserAttributeMap` attribute ON
usermap.id = attribute.fdPositionUserMapID
SET usermap.fdStatus = 1
WHERE usermap.fdPositionID IN ( 4, 5 )
AND usermap.fdStatus =0
AND attribute.id IS NULL
LEFT JOIN `tbPositionUserAttributeMap` attribute ON
usermap.id = attribute.fdPositionUserMapID
SET usermap.fdStatus = 1
WHERE usermap.fdPositionID IN ( 4, 5 )
AND usermap.fdStatus =0
AND attribute.id IS NULL
最新文章
- 通过AngularJS实现前端与后台的数据对接(二)——服务(service,$http)篇
- HTML5播放暂停音乐
- hadoop 8088无法访问
- Andorid视觉新冲击-Material design语言
- Android - 文件读写操作 总结
- OPENCV3.1+VS 坑我笔记!
- Android 类似时间轴的实现
- 安装WP8 SDK出现“根据当前系统时钟或签名文件中的时间戳验证时要求的证书不在有效期内”的解决办法
- 在Windows下基于libx264.a的Qt 4.8.2视频压缩
- Android M(6.0) 权限爬坑之旅
- Implement Trie (Prefix Tree) ——LeetCode
- maven项目java包名的路径问题
- iOS基础 - 相片浏览器
- 向输出到console的文字加样式
- 学习笔记之09小练习题(js:从小到大输出三个任意数,查成绩,相亲题,查体重,一元二次方程求根)
- Linux 删除目录与文件
- JAVA基础—适配器设计模式
- Java 学习笔记 网络编程 使用Socket传输文件 CS模式
- git push后出错
- k64 datasheet学习笔记50---GPIO