a.id AS "id", a.pool_code AS "poolCode", a.prize_code AS "prizeCode", a.prize_name AS "prizeName", a.total_num AS "totalNum", a.num AS "num", a.face_price AS "facePrice", a.create_date AS "createDate", a.del_flag AS "delFlag" SELECT FROM dog_prize_pool a WHERE a.id = #{id} SELECT FROM dog_prize_pool a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} SELECT FROM dog_prize_pool a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} INSERT INTO dog_prize_pool( id, pool_code, prize_code, prize_name, total_num, num, face_price, create_date, del_flag ) VALUES ( #{id}, #{poolCode}, #{prizeCode}, #{prizeName}, #{totalNum}, #{num}, #{facePrice}, #{createDate}, #{delFlag} ) UPDATE dog_prize_pool SET pool_code = #{poolCode}, prize_code = #{prizeCode}, prize_name = #{prizeName}, total_num = #{totalNum}, num = #{num}, face_price = #{facePrice} WHERE id = #{id} UPDATE dog_prize_pool SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} SELECT FROM dog_prize_pool a a.del_flag = '0' and a.pool_code = #{poolCode} and a.total_num-a.num>0 SELECT FROM dog_prize_pool a WHERE a.del_flag = '0' and a.pool_code = #{poolCode} and a.prize_name = #{prizeName} limit 1 UPDATE dog_prize_pool SET num=num+1 WHERE id = #{id} and num = #{num}