DB Migration into Excel

Concluído Postado há 7 anos Pago na entrega
Concluído Pago na entrega

I have three DB tables with records in the following format:

********

Table 1 - Country:

insert into `countries` (`id`, `iso`, `name`, `nicename`, `iso3`, `numcode`, `phonecode`) values('10','AR','ARGENTINA','Argentina','ARG','32','54');

Table 2 - Region:

insert into `regions` (`id`, `country`, `code`, `name`, `latitude`, `longitude`, `cities`) values('94','AR','01','Buenos Aires','0','0','205');

Table 3 - City:

insert into `cities` (`id`, `country`, `region`, `name`, `latitude`, `longitude`) values('142','AR','01','Azul','[url removed, login to view]','[url removed, login to view]');

********

Each table has 1000's of records. They need to be migrated into excel file with the following 4 columns:

Continent, Country, State/Province, City/Town

At the end each sample row should look like this:

South America, Argentina, Buenos Aires, Azul

* Obviously you will need to add a continent to each country as there is no one presented in the DB.

Excel MySQL PHP

ID do Projeto: #11861350

Sobre o projeto

26 propostas Projeto remoto Ativo em há 7 anos

Concedido a:

$15 USD em 1 dia
(54 Comentários)
4.6

26 freelancers estão ofertando em média $27 nesse trabalho

saadrashad

i need to know which database is this currently? secondly what are common fields? or reference fields? currently the set example dont seems to be accurate as in table 1- Ar is ISO in table 2- Ar is country in tab Mais

$30 USD in 0 dias
(136 Comentários)
6.1
Max01

hello hope you are doing well I am interested to work on this project. Gladly waiting to serve you with my extensive 8+ years skills.

$30 USD in 0 dias
(206 Comentários)
6.3
MohsanEijaz

https://www.freelancer.com/u/MohsanEijaz.html I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I Mais

$30 USD em 1 dia
(60 Comentários)
5.7
catstevens2009

Hi there! Have done this type of work before and am an excel/db expert! Please feel free to ping me with any additional information or with questions if any! Thanks! -Steve

$30 USD em 1 dia
(82 Comentários)
5.6
amjohn

Hi, i understand your task. i can do it and provide you required information in excel as you need. i am a php programmer and expert in database. i can do it in time limit. Thanking you.

$20 USD em 1 dia
(21 Comentários)
5.4
KavTan

Hi, I am a professional freelancer, and I can complete your task effectively and efficiently in a timely manner.

$35 USD em 1 dia
(38 Comentários)
5.4
deepbansal1111

hi I can complete your job easily. Even i can complete your job within 2 hours. Let's discuss rest of the things on chat. Regards

$35 USD em 1 dia
(5 Comentários)
4.8
karlmc15

let me know Mais

$55 USD em 1 dia
(28 Comentários)
4.7
dunnothrasher

Hi. i was jus t passing by and i noticed your project. seems pretty easy. i can do it right now. Do you need this in some language specifically (PHP, Python)

$15 USD em 1 dia
(15 Comentários)
4.2
pankajrana195

With 6.5 years work experience, I am confident that I am the best candidate for your vacancy. My Expertise Areas is Email and Contacts Collections ,Scraping data, On/Off line Data Entry, Product Research, Photoshop, Co Mais

$30 USD em 1 dia
(33 Comentários)
4.3
ssshukla

i have 6+ years experience and also have a great knowledge in the ms-sql and also in mysql and mongodb.

$17 USD em 1 dia
(32 Comentários)
4.1
Ayo25

I am a statistician with advanced knowledge of microsoft excel. I have experience with data entry and statistical calculations.I work fast and deliver my projects on time. Looking forward to working with you. Thank you Mais

$30 USD em 1 dia
(5 Comentários)
3.5
hyadesfreelancer

PHP,PDO, Core-php, CakePHP, CodeIgniter, Laravel, Yii, Mysql, HTML, HTML5, CSS, JavaScript, Angular js, jquery, AJax, Joomla, E-Commerce Wordpress, Woo-commerce, Open-cart And BUG FIXING etc. When we work for clie Mais

$25 USD in 0 dias
(7 Comentários)
2.7
PRTechno7868

We are PR Technologies. We have a team of experienced Java developers, who works together and contribute to Develop Quality Products. So, if you show some trust, then we will guaranteed for a Best products. Thanks & Re Mais

$30 USD em 1 dia
(4 Comentários)
2.5
KiranRohra

Hey, I will do your work on time with complete requirements. I have knowledge of DB, PHP and also familiar with excel. I will do your work on time with complete requirements.

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

I have done such projects earlier. Currently working as developer and handling backend too. You will get full support from me in future also. Thank you in advance.

$25 USD in 3 dias
(0 Comentários)
0.0