content_id, content_title, create_Date, end_date, preheat_date, preheat_img, start_date, status, thumb_min_url, thumb_url, user_count, user_id, video_time, video_url content_detail select , from cab_live_content where content_id = #{contentId,jdbcType=INTEGER} delete from cab_live_content where content_id = #{contentId,jdbcType=INTEGER} insert into cab_live_content (content_id, content_title, create_Date, end_date, preheat_date, preheat_img, start_date, status, thumb_min_url, thumb_url, user_count, user_id, video_time, video_url, content_detail ) values (#{contentId,jdbcType=INTEGER}, #{contentTitle,jdbcType=VARCHAR}, #{createDate,jdbcType=DATE}, #{endDate,jdbcType=DATE}, #{preheatDate,jdbcType=DATE}, #{preheatImg,jdbcType=VARCHAR}, #{startDate,jdbcType=DATE}, #{status,jdbcType=VARCHAR}, #{thumbMinUrl,jdbcType=VARCHAR}, #{thumbUrl,jdbcType=VARCHAR}, #{userCount,jdbcType=INTEGER}, #{userId,jdbcType=BIGINT}, #{videoTime,jdbcType=VARCHAR}, #{videoUrl,jdbcType=VARCHAR}, #{contentDetail,jdbcType=LONGVARCHAR} ) insert into cab_live_content content_id, content_title, create_Date, end_date, preheat_date, preheat_img, start_date, status, thumb_min_url, thumb_url, user_count, user_id, video_time, video_url, content_detail, #{contentId,jdbcType=INTEGER}, #{contentTitle,jdbcType=VARCHAR}, #{createDate,jdbcType=DATE}, #{endDate,jdbcType=DATE}, #{preheatDate,jdbcType=DATE}, #{preheatImg,jdbcType=VARCHAR}, #{startDate,jdbcType=DATE}, #{status,jdbcType=VARCHAR}, #{thumbMinUrl,jdbcType=VARCHAR}, #{thumbUrl,jdbcType=VARCHAR}, #{userCount,jdbcType=INTEGER}, #{userId,jdbcType=BIGINT}, #{videoTime,jdbcType=VARCHAR}, #{videoUrl,jdbcType=VARCHAR}, #{contentDetail,jdbcType=LONGVARCHAR}, update cab_live_content content_title = #{contentTitle,jdbcType=VARCHAR}, create_Date = #{createDate,jdbcType=DATE}, end_date = #{endDate,jdbcType=DATE}, preheat_date = #{preheatDate,jdbcType=DATE}, preheat_img = #{preheatImg,jdbcType=VARCHAR}, start_date = #{startDate,jdbcType=DATE}, status = #{status,jdbcType=VARCHAR}, thumb_min_url = #{thumbMinUrl,jdbcType=VARCHAR}, thumb_url = #{thumbUrl,jdbcType=VARCHAR}, user_count = #{userCount,jdbcType=INTEGER}, user_id = #{userId,jdbcType=VARCHAR}, video_time = #{videoTime,jdbcType=VARCHAR}, video_url = #{videoUrl,jdbcType=VARCHAR}, content_detail = #{contentDetail,jdbcType=LONGVARCHAR}, where content_id = #{contentId,jdbcType=INTEGER} update cab_live_content set content_title = #{contentTitle,jdbcType=VARCHAR}, create_Date = #{createDate,jdbcType=DATE}, end_date = #{endDate,jdbcType=DATE}, preheat_date = #{preheatDate,jdbcType=DATE}, preheat_img = #{preheatImg,jdbcType=VARCHAR}, start_date = #{startDate,jdbcType=DATE}, status = #{status,jdbcType=VARCHAR}, thumb_min_url = #{thumbMinUrl,jdbcType=VARCHAR}, thumb_url = #{thumbUrl,jdbcType=VARCHAR}, user_count = #{userCount,jdbcType=INTEGER}, user_id = #{userId,jdbcType=VARCHAR}, video_time = #{videoTime,jdbcType=VARCHAR}, video_url = #{videoUrl,jdbcType=VARCHAR}, content_detail = #{contentDetail,jdbcType=LONGVARCHAR} where content_id = #{contentId,jdbcType=INTEGER} update cab_live_content set content_title = #{contentTitle,jdbcType=VARCHAR}, create_Date = #{createDate,jdbcType=DATE}, end_date = #{endDate,jdbcType=DATE}, preheat_date = #{preheatDate,jdbcType=DATE}, preheat_img = #{preheatImg,jdbcType=VARCHAR}, start_date = #{startDate,jdbcType=DATE}, status = #{status,jdbcType=VARCHAR}, thumb_min_url = #{thumbMinUrl,jdbcType=VARCHAR}, thumb_url = #{thumbUrl,jdbcType=VARCHAR}, user_count = #{userCount,jdbcType=INTEGER}, user_id = #{userId,jdbcType=VARCHAR}, video_time = #{videoTime,jdbcType=VARCHAR}, video_url = #{videoUrl,jdbcType=VARCHAR} where content_id = #{contentId,jdbcType=INTEGER} select , from cab_live_content where 1=1 and content_title = #{title,jdbcType=INTEGER} order by create_Date DESC limit #{start},#{limit} select count(*) from cab_live_content where 1=1 and content_title = #{title,jdbcType=INTEGER} select , from cab_live_content where 1=1 and content_id != #{selectId,jdbcType=INTEGER} and preheat_date > #{dateString} order by start_date desc