在mssql 的存储过程中有这么个update更新临时表的语句 请教在mysql存储过程中的写法
UPDATE #TEMP
SET WBJF = ISNULL((SELECT ISNULL(WBJF,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
WBDF = ISNULL((SELECT ISNULL(WBDF,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
JFSL = ISNULL((SELECT ISNULL(JFSL,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
DFSL = ISNULL((SELECT ISNULL(DFSL,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
RMBJ = ISNULL((SELECT ISNULL(JFSJ,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
RMBD = ISNULL((SELECT ISNULL(DFSJ,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0), YEWB = ISNULL((SELECT SUM(ISNULL(WBJF,0)-ISNULL(WBDF,0)) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)<=MONTH(#TEMP.PZRQ)),0),
YESL = ISNULL((SELECT SUM(ISNULL(JFSL,0)-ISNULL(DFSL,0)) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)<=MONTH(#TEMP.PZRQ)),0),
YE = ISNULL((SELECT SUM(ISNULL(JFSJ,0)-ISNULL(DFSJ,0)) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)<=MONTH(#TEMP.PZRQ)),0)
WHERE XH = 2
UPDATE #TEMP
SET WBJF = ISNULL((SELECT ISNULL(WBJF,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
WBDF = ISNULL((SELECT ISNULL(WBDF,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
JFSL = ISNULL((SELECT ISNULL(JFSL,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
DFSL = ISNULL((SELECT ISNULL(DFSL,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
RMBJ = ISNULL((SELECT ISNULL(JFSJ,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0),
RMBD = ISNULL((SELECT ISNULL(DFSJ,0) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)=MONTH(#TEMP.PZRQ)),0), YEWB = ISNULL((SELECT SUM(ISNULL(WBJF,0)-ISNULL(WBDF,0)) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)<=MONTH(#TEMP.PZRQ)),0),
YESL = ISNULL((SELECT SUM(ISNULL(JFSL,0)-ISNULL(DFSL,0)) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)<=MONTH(#TEMP.PZRQ)),0),
YE = ISNULL((SELECT SUM(ISNULL(JFSJ,0)-ISNULL(DFSJ,0)) FROM #TEMP_QCFS AS S WHERE MONTH(S.PZRQ)<=MONTH(#TEMP.PZRQ)),0)
WHERE XH = 2
临时表不能reopen