<insert id="insert">

        insert into ete_buy_house_info         (PROVINCE,CITY,COUNTY,COMMUNITY_NAME,SHORT_NAME,ADDRESS,BUILDING,HOUSE_UNIT,HOUSE_FLOOR,ALL_FLOOR,HOUSE_NUMBER,BEDROOM_NUMBER,LIVINGROOM_NUMBER,TOILET_NUMBER,BUILDING_ACREAGE,UNIT_PRICE,HOUSE_PRICE,BUILDING_NATURE,BUILDING_USE,BUILDING_PERMEATION,BUILDING_TYPE,STATUS_DESC,ROOM_BOOK,ROOM_KEY,ROOM_AGE,ROOM_COMPLEMENT,ROOM_DECORATE,GARAGE,GARAGE_AREA,GARAGE_PRICE,BELOWHOUSE,BELOWHOUSE_AREA,BELOWHOUSE_PRICE,ALL_PRICE,SHARE_HOUSE,MASTER_NAME,MASTER_PHONE,CREATE_TIME,CREATE_USER,CREATE_USER_PHONE,BUYER_NAME,BUYER_PHONE,BUYER_NO,BUYER_TIME,MAIN_HOUSE,HOUSE_COLLETION,PAYMENT_TYPE,REMARK)         values         (#{province},#{city},#{county},#{communityName},#{shortName},#{address},#{building},#{houseUnit},#{houseFloor},#{allFloor},#{houseNumber},#{bedroomNumber},#{livingroomNumber},#{toiletNumber},#{buildingAcreage},#{unitPrice},#{housePrice},#{buildingNature},#{buildingUse},#{buildingPermeation},#{buildingType},#{statusDesc},#{roomBook},#{roomKey},#{roomAge},#{roomComplement},#{roomDecorate},#{garage},#{garageArea},#{garagePrice},#{belowHouse},#{belowHouseArea},#{belowHousePrice},#{allPrice},#{shareHouse},#{masterName},#{masterPhone},UNIX_TIMESTAMP(),#{createUser},#{createUserPhone},#{buyerName},#{buyerPhone},#{buyerNo},#{buyerTime},#{mainHouse},#{houseColletion},#{paymentType},#{remark})     </insert>