SQL to CSV format

SQL to CSV format

Closed - This job posting has been filled and work has been completed.

Job Description

I have three databases with MySQL dumps for each. 4.0 MB, 9.23MB, 30MB

I need them combined into one large .csv file for spreadsheet analysis.

I will then need to have this data orgnaized into columns to match the fields in the structured csv file. There will be many fields that will not need to be imported.

All three databases have a common field so the data can stay organized.

The we need to have this data organized into a csv file that will need importing.

Here are the field types that need to be matched:

iproperty|id iproperty|mls_id iproperty|stype iproperty|stype_freq iproperty|street_num iproperty|street iproperty|street2 iproperty|region iproperty|apt iproperty|title iproperty|short_description iproperty|description iproperty|agent_notes iproperty|city iproperty|locstate iproperty|province iproperty|postcode iproperty|county iproperty|country iproperty|latitude iproperty|longitude iproperty|price iproperty|call_for_price iproperty|income iproperty|tax iproperty|reception iproperty|beds iproperty|baths iproperty|sqft iproperty|lotsize iproperty|lot_acres iproperty|yearbuilt iproperty|heat iproperty|cool iproperty|fuel iproperty|garage_type iproperty|garage_size iproperty|zoning iproperty|frontage iproperty|siding iproperty|roof iproperty|propview iproperty|school_district iproperty|lot_type iproperty|style iproperty|hoa iproperty|reo iproperty|metadesc iproperty|metakey iproperty|access iproperty|listing_office iproperty|category iproperty|amenities iproperty_agents|fname|1 iproperty_agents|lname|1 iproperty_agents|email|1 iproperty_agents|phone|1 iproperty_agents|mobile|1 iproperty_agents|fax|1 iproperty_agents|street|1 iproperty_agents|street2|1 iproperty_agents|city|1 iproperty_agents|locstate|1 iproperty_agents|province|1 iproperty_agents|postcode|1 iproperty_agents|country|1 iproperty_agents|website|1 iproperty_agents|bio|1 iproperty_agents|icon|1 iproperty_agents|msn|1 iproperty_agents|skype|1 iproperty_agents|gtalk|1 iproperty_agents|alicense|1 iproperty_agents|id|1 iproperty_agents|fname|2 iproperty_agents|lname|2 iproperty_agents|email|2 iproperty_agents|phone|2 iproperty_agents|mobile|2 iproperty_agents|fax|2 iproperty_agents|street|2 iproperty_agents|street2|2 iproperty_agents|city|2 iproperty_agents|locstate|2 iproperty_agents|province|2 iproperty_agents|postcode|2 iproperty_agents|country|2 iproperty_agents|website|2 iproperty_agents|bio|2 iproperty_agents|icon|2 iproperty_agents|msn|2 iproperty_agents|skype|2 iproperty_agents|gtalk|2 iproperty_agents|alicense|2 iproperty_agents|id|2 iproperty_companies|name iproperty_companies|description iproperty_companies|street iproperty_companies|city iproperty_companies|locstate iproperty_companies|province iproperty_companies|postcode iproperty_companies|country iproperty_companies|fax iproperty_companies|phone iproperty_companies|email iproperty_companies|website iproperty_companies|icon iproperty_companies|clicense iproperty_companies|id iproperty_images|title|1 iproperty_images|description|1 iproperty_images|fname|1 iproperty_images|remote|1 iproperty_images|title|2 iproperty_images|description|2 iproperty_images|fname|2 iproperty_images|remote|2 iproperty_images|title|3 iproperty_images|description|3 iproperty_images|fname|3 iproperty_images|remote|3 iproperty_images|title|4

Other open jobs by this client