id, carNo, carModel, carColor, carBrand, carCategory, driverName, driverLicenseNo, isImport, idCardNo, fullName, sex, nationality, region, back, face select from temp_activity_info where id = #{id} delete from temp_activity_info where id = #{id} insert into temp_activity_info (id, carNo, carModel, carColor, carBrand, carCategory, driverName, driverLicenseNo, isImport, idCardNo, fullName, sex, nationality, region, back, face) values (#{id}, #{carNo}, #{carModel}, #{carColor}, #{carBrand}, #{carCategory}, #{driverName}, #{driverLicenseNo}, #{isImport}, #{idCardNo}, #{fullName}, #{sex}, #{nationality}, #{region}, #{back}, #{face}) insert into temp_activity_info id, carNo, carModel, carColor, carBrand, carCategory, driverName, driverLicenseNo, isImport, idCardNo, fullName, sex, nationality, region, back, face, #{id}, #{carNo}, #{carModel}, #{carColor}, #{carBrand}, #{carCategory}, #{driverName}, #{driverLicenseNo}, #{isImport}, #{idCardNo}, #{fullName}, #{sex}, #{nationality}, #{region}, #{back}, #{face}, update temp_activity_info carNo = #{carNo}, carModel = #{carModel}, carColor = #{carColor}, carBrand = #{carBrand}, carCategory = #{carCategory}, driverName = #{driverName}, driverLicenseNo = #{driverLicenseNo}, isImport = #{isImport}, idCardNo = #{idCardNo}, fullName = #{fullName}, sex = #{sex}, nationality = #{nationality}, region = #{region}, back = #{back}, face = #{face}, where id = #{id} update temp_activity_info set carNo = #{carNo}, carModel = #{carModel}, carColor = #{carColor}, carBrand = #{carBrand}, carCategory = #{carCategory}, driverName = #{driverName}, driverLicenseNo = #{driverLicenseNo}, isImport = #{isImport}, idCardNo = #{idCardNo}, fullName = #{fullName}, sex = #{sex}, nationality = #{nationality}, region = #{region}, back = #{back}, face = #{face} where id = #{id} select from temp_activity_info and carCategory=#{carCategory} and sex=#{sex}