id, cost_cac, cost_cacib, cost_alone SELECT cost.id, cost.cost_cacib, cost.cost_cac, cost.cost_alone FROM tab_games tab LEFT JOIN cku_match_cost cost ON tab.cost_id = cost.id WHERE tab.id = #{id,jdbcType=INTEGER} delete from cku_match_cost where id = #{id,jdbcType=INTEGER} insert into cku_match_cost (id, cost_cac, cost_cacib, cost_alone) values (#{id,jdbcType=INTEGER}, #{costCac,jdbcType=VARCHAR}, #{costCacib,jdbcType=VARCHAR}, #{costAlone,jdbcType=VARCHAR}) insert into cku_match_cost id, cost_cac, cost_cacib, cost_alone, #{id,jdbcType=INTEGER}, #{costCac,jdbcType=VARCHAR}, #{costCacib,jdbcType=VARCHAR}, #{costAlone,jdbcType=VARCHAR}, update cku_match_cost cost_cac = #{costCac,jdbcType=VARCHAR}, cost_cacib = #{costCacib,jdbcType=VARCHAR}, cost_alone = #{costAlone,jdbcType=VARCHAR}, where id = #{id,jdbcType=INTEGER} update cku_match_cost set cost_cac = #{costCac,jdbcType=VARCHAR}, cost_cacib = #{costCacib,jdbcType=VARCHAR}, cost_alone = #{costAlone,jdbcType=VARCHAR} where id = #{id,jdbcType=INTEGER}