id, fileId, `name`, fileType, description, addTime, updateTime select from drawing where id = #{id,jdbcType=BIGINT} delete from drawing where id = #{id,jdbcType=BIGINT} insert into drawing (fileId, `name`, fileType, description, addTime, updateTime ) values (#{fileId,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, #{fileType,jdbcType=VARCHAR}, #{description,jdbcType=VARCHAR}, #{addTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP} ) insert into drawing fileId, `name`, fileType, description, addTime, updateTime, #{fileId,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, #{fileType,jdbcType=VARCHAR}, #{description,jdbcType=VARCHAR}, #{addTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP}, update drawing fileId = #{fileId,jdbcType=VARCHAR}, `name` = #{name,jdbcType=VARCHAR}, fileType = #{fileType,jdbcType=VARCHAR}, description = #{description,jdbcType=VARCHAR}, addTime = #{addTime,jdbcType=TIMESTAMP}, updateTime = #{updateTime,jdbcType=TIMESTAMP}, where id = #{id,jdbcType=BIGINT} update drawing set fileId = #{fileId,jdbcType=VARCHAR}, `name` = #{name,jdbcType=VARCHAR}, fileType = #{fileType,jdbcType=VARCHAR}, description = #{description,jdbcType=VARCHAR}, addTime = #{addTime,jdbcType=TIMESTAMP}, updateTime = #{updateTime,jdbcType=TIMESTAMP} where id = #{id,jdbcType=BIGINT} select t1.id, t1.fileId, t1.`name`, t1.fileType, t1.description, t1.addTime, t1.updateTime, t3.fullName, t3.id as venueId from drawing t1 left join venue_drawing t2 on t1.id = t2.drawingId left join base_venue t3 on t2.venueId = t3.id order by t1.addTime desc