export_to_csv

# Example but doesnt put text fields in quotes
# Optionally statement is supposed to do that but did not
# Wound up exporting using the Query Browser Save As function with only a subset of columns exported

Select
parcel_id
,parcel_id_fips
,parking_space_daily
,parking_space_hourly
,hschool_id
,city_id
,minority_id
,census_tract_id
,grid_id
,tod_id
,census_block_id
,y_coord_sp
,county_id
,plan_type_id
,use_code
,transit_buffer_id
,school_district_id
,gross_sqft
,is_inside_urban_growth_boundary
,park_buffer_id
,x_coord_sp
,elem_id
,is_waterfront
,growth_center_id
,zip_id
,parking_price_hourly
,hex_id
,regional_geography_id
,large_area_id
,mschool_id
,land_value
,hct_block_id
,baseyear_built
,poverty_id
,zone_id
,tractcity_id
,faz_id
,growth_amenities_id
,is_in_transit_zone
,parking_price_daily
,subarea_id
,census_block_group_id
,faz_group_id
,land_use_type_id
,mix_split_id
,parcel_sqft
,uga_buffer_id
,exemption
,stacked_parcel_id
,stacked_flag
,original_parcel_id
,address
,census_2010_block_id
from parcels
Into Outfile 'C:/mhs_workfiles/parcels.csv'
#FIELDS ENCLOSED BY '"'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'