Em Andamento

mysql import

I've two databases; I need to write a SQL script which let me import data from one table format to another.

## Deliverables

the first database is a dump of [url removed, login to view] DB which has a structure similar to this:

**geoname**

fcode, country, admin1, admin2, admin3, admin4

where fcode is ENUM(ADM1,ADM2,ADM3,ADM4)

(there are other values for fcode, but they're beyond the purpose of this bid.)

I've then another DB with this scheme:

**zones**

zone_id, country_id, code, name

**localities_level_1**

id, country, name

**localities_level_1_zones**

level_1_id, zone_id

**localities_level_2**

id, level_1_id, name

**localities_level_3**

id, level_2_id, name

as you may see the second format discard a subdivision.

In fact, not all countries have a 4 level subdivision, mostly has just 3 levels.

To integrate this into the new format, you must upload:

for countries with ADM4:

ADM1 -> level_1

ADM2 -> level_2

ADM4 -> level_3

for countries without ADM4:

ADM1 -> level_1

ADM2 -> level_2

ADM3 -> level_3

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software

Ver mais: mysql org, sql import, import two, import sql, mysql structure, geonames mysql import, php mysql import script, import sql database mysql, sql script mysql, import data database database, write code mysql, import upload, geonames mysql dump, mysql import dump, mysql import script, php sql import, mysql level, geonames mysql, zones php mysql, code import, data upload mysql, mysql script management, php upload script mysql, import mysql sql, import dump php

Acerca do Empregador:
( 15 comentários ) Torino, Italy

ID do Projeto: #3034931

Premiar a:

davidtheele

See private message.

$34 USD em 2 dias
(11 Avaliações)
3.4

2 freelancers estão ofertando em média $38 para este trabalho

vst0201

See private message.

$42.5 USD in 2 dias
(0 Comentários)
0.0