a.id AS "id", a.file_type AS "fileType", a.fild_id AS "fildId", a.appraisal_id AS "appraisalId", a.file_sort AS "fileSort", a.business_code AS "businessCode" SELECT FROM dog_video_appraisal_file a WHERE a.id = #{id} SELECT FROM dog_video_appraisal_file a AND appraisal_id = #{appraisalId} AND file_type = #{fileType} AND business_code = #{businessCode} ORDER BY ${page.orderBy} ORDER BY a.file_sort ASC SELECT FROM dog_video_appraisal_file a ORDER BY ${page.orderBy} INSERT INTO dog_video_appraisal_file( id, file_type, fild_id, appraisal_id, file_sort, business_code ) VALUES ( #{id}, #{fileType}, #{fildId}, #{appraisalId}, #{fileSort}, #{businessCode} ) UPDATE dog_video_appraisal_file SET file_type = #{fileType}, fild_id = #{fildId}, appraisal_id = #{appraisalId}, file_sort = #{fileSort}, business_code = #{businessCode} WHERE id = #{id} DELETE FROM dog_video_appraisal_file WHERE id = #{id}