begin update T_AXWH_PICTURE set PICTURE_NAME = ( select PICTURE_NAME from T_AXWH_PICTURE where PICTURE_ID=#{picture_id,jdbcType=VARCHAR} ) where PICTURE_ID = ( select tp.PICTURE_ID from T_AXWH_TEMPLATE_SHOW ts inner join T_AXWH_PICTURE tp on ts.PICTURE_ID = tp.PICTURE_ID where ts.SHOW_ID = #{show_id,jdbcType=VARCHAR} ); update T_AXWH_TEXT set TEXT_CONTEXT = ( select TEXT_CONTEXT from T_AXWH_TEXT where TEXT_ID=#{text_id,jdbcType=VARCHAR} ) where TEXT_ID =( select tt.TEXT_ID from T_AXWH_TEMPLATE_SHOW ts inner join T_AXWH_TEXT tt on ts.TEXT_ID = tt.TEXT_ID where ts.SHOW_ID = #{show_id,jdbcType=VARCHAR} ); end;
看得头晕