SQL: <update id="updateSalesManId" parameterType="map" > update T_BC_LISTINGIMAGE <set> FKSALESMANID='${salesmanId}' </set> where fhouseid='${roomlistingId}' AND fid in (select fid from ( select fid from T_BC_LISTINGIMAGE ORDER BY fcreatetime desc limit ${count} ) t) </update>
MySql update order by limit 同时使用需要将limit的sql再包一层
最新推荐文章于 2022-12-18 02:33:35 发布