下面的 更新操作 可以直接执行,但是,代码用动态sql执行时,一运行,mysql就停止服务了。
急......求高人指点 SET @P_UpdateMoralTotal = CONCAT(
' update t_termtotalscore as tt ,',
' (SELECT SUM(t.score) AS score,T.STUDID AS studid FROM ',
' (select * from temp_11_termscore AS TS ',
' INNER JOIN (SELECT STDID FROM t_clsstd WHERE CLASSID = ',
352,' AND FLAG = \'1\') S ON TS.STUDID = S.STDID ',
') AS t ',
' INNER JOIN (select * from t_AssessmentRules where parentId = ',8,' and enable = \'1\') AS a ON t.assmId = a.id ',
' GROUP BY T.STUDID ',
' ) AS ts set tt.moralSum = tt.moralSum + ts.score where ts.studid = tt.studentid and tt.termid = F_getCurrentTermId()'
);
PREPARE P_UpdateMoralTotal FROM @P_UpdateMoralTotal;
EXECUTE P_UpdateMoralTotal;
DEALLOCATE PREPARE P_UpdateMoralTotal;
急......求高人指点 SET @P_UpdateMoralTotal = CONCAT(
' update t_termtotalscore as tt ,',
' (SELECT SUM(t.score) AS score,T.STUDID AS studid FROM ',
' (select * from temp_11_termscore AS TS ',
' INNER JOIN (SELECT STDID FROM t_clsstd WHERE CLASSID = ',
352,' AND FLAG = \'1\') S ON TS.STUDID = S.STDID ',
') AS t ',
' INNER JOIN (select * from t_AssessmentRules where parentId = ',8,' and enable = \'1\') AS a ON t.assmId = a.id ',
' GROUP BY T.STUDID ',
' ) AS ts set tt.moralSum = tt.moralSum + ts.score where ts.studid = tt.studentid and tt.termid = F_getCurrentTermId()'
);
PREPARE P_UpdateMoralTotal FROM @P_UpdateMoralTotal;
EXECUTE P_UpdateMoralTotal;
DEALLOCATE PREPARE P_UpdateMoralTotal;
贴上.err日志看看