gistfile1.sql

INSERT INTO rental_properties 
(
    property_name,
    rental_unit_type,
    house_number,
    street_name,
    street_type,
    city,
    zip,
    neighborhood,
    owner_company_manager,
    applicant_name,
    applicant_addr,
    applicant_city,
    applicatn_state,
    applicant_zip,
    property_manager,
    beds,
    bath
    
)
VALUES

    SELECT 
    
    NULL as property_name,
    0 as rental_unit_type,
    `COL 1` as house_number,
    `COL 2` as street_name,
    `COL 3` as street_type,
    `COL 4` as city,
    `COL 5` as zip,
    `COL 6` as neighborhood,
    '' as owner_company_manager,
    `COL 9` as applicant_name,
    `COL 10` as applicant_addr,
    `COL 11` as applicant_city,
    `COL 12` as applicant_state,
    `COL 13` as applicant_zip,
    '' as property_manager,
    0 as beds,
    0 as bath
    
    FROM `TABLE 13`