d_content, d_content1, d_content2
insert into tab_games (id, showSystem, show_num,
starting_data, ending_data, show_name,
show_location, show_enrolment, add_data,
modifi_data, bmFei, del_tag,
cku_endtime, cku_zhuantiweb, cku_picture1,
cku_picture2, cku_caipanid, cku_picture3,
cku_tel, cku_tableweb, cku_slzweb,
cku_gjdlweb, cku_jfweb, privileges_enrolment,
gameType, organizer, showCancel,
venue_id, d_content,
d_content1, d_content2)
values (#{id,jdbcType=INTEGER}, #{showsystem,jdbcType=CHAR}, #{showNum,jdbcType=VARCHAR},
#{startingData,jdbcType=TIMESTAMP}, #{endingData,jdbcType=TIMESTAMP}, #{showName,jdbcType=VARCHAR},
#{showLocation,jdbcType=VARCHAR}, #{showEnrolment,jdbcType=VARCHAR}, #{addData,jdbcType=TIMESTAMP},
#{modifiData,jdbcType=TIMESTAMP}, #{bmfei,jdbcType=DECIMAL}, #{delTag,jdbcType=CHAR},
#{ckuEndtime,jdbcType=TIMESTAMP}, #{ckuZhuantiweb,jdbcType=VARCHAR}, #{ckuPicture1,jdbcType=VARCHAR},
#{ckuPicture2,jdbcType=VARCHAR}, #{ckuCaipanid,jdbcType=VARCHAR}, #{ckuPicture3,jdbcType=VARCHAR},
#{ckuTel,jdbcType=VARCHAR}, #{ckuTableweb,jdbcType=VARCHAR}, #{ckuSlzweb,jdbcType=VARCHAR},
#{ckuGjdlweb,jdbcType=VARCHAR}, #{ckuJfweb,jdbcType=VARCHAR}, #{privilegesEnrolment,jdbcType=VARCHAR},
#{gametype,jdbcType=CHAR}, #{organizer,jdbcType=CHAR}, #{showcancel,jdbcType=CHAR},
#{venueId,jdbcType=INTEGER}, #{dContent,jdbcType=LONGVARCHAR},
#{dContent1,jdbcType=LONGVARCHAR}, #{dContent2,jdbcType=LONGVARCHAR})
insert into tab_games
id,
showSystem,
赛事编号,
开始日期,
结束日期,
赛事名称,
赛事地点,
赛事报名,
添加日期,
修改日期,
bmFei,
del_tag,
cku_endtime,
cku_zhuantiweb,
cku_picture1,
cku_picture2,
cku_caipanid,
cku_picture3,
cku_tel,
cku_tableweb,
cku_slzweb,
cku_gjdlweb,
cku_jfweb,
报名优惠,
gameType,
organizer,
showCancel,
venue_id,
d_content,
d_content1,
d_content2,
main_game_name,
top_dog,
shows_detail,
#{id,jdbcType=VARCHAR},
#{showsystem,jdbcType=CHAR},
#{showNum,jdbcType=VARCHAR},
#{startingData,jdbcType=TIMESTAMP},
#{endingData,jdbcType=TIMESTAMP},
#{showName,jdbcType=VARCHAR},
#{showLocation,jdbcType=VARCHAR},
#{showEnrolment,jdbcType=VARCHAR},
#{addData,jdbcType=TIMESTAMP},
#{modifiData,jdbcType=TIMESTAMP},
#{bmfei,jdbcType=DECIMAL},
#{delTag,jdbcType=CHAR},
#{ckuEndtime,jdbcType=TIMESTAMP},
#{ckuZhuantiweb,jdbcType=VARCHAR},
#{ckuPicture1,jdbcType=VARCHAR},
#{ckuPicture2,jdbcType=VARCHAR},
#{ckuCaipanid,jdbcType=VARCHAR},
#{ckuPicture3,jdbcType=VARCHAR},
#{ckuTel,jdbcType=VARCHAR},
#{ckuTableweb,jdbcType=VARCHAR},
#{ckuSlzweb,jdbcType=VARCHAR},
#{ckuGjdlweb,jdbcType=VARCHAR},
#{ckuJfweb,jdbcType=VARCHAR},
#{privilegesEnrolment,jdbcType=VARCHAR},
#{gametype},
#{organizer,jdbcType=CHAR},
#{showcancel,jdbcType=CHAR},
#{venueId,jdbcType=INTEGER},
#{dContent,jdbcType=LONGVARCHAR},
#{dContent1,jdbcType=LONGVARCHAR},
#{dContent2,jdbcType=LONGVARCHAR},
#{mainGameName,jdbcType=VARCHAR},
#{topDog,jdbcType=VARCHAR},
#{showsDetail,jdbcType=VARCHAR},
update show_main
referee = #{ckuCaipanid,jdbcType=VARCHAR},
venues_id = #{venueId,jdbcType=VARCHAR}
where id = #{id,jdbcType=VARCHAR}