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','-36.7833','-59.85');
********
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.
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 table 3- Ar is country
need to clear these things.
though it can cab be exported to excel easily no issues
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 believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities.
“Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.”
I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance.
Regards,
Mohsan Ijaz
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
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.
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)
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, Content writing, Data entry, Internet Research, PDF to Word and Excel, Word to excel, excel and Formatting-Automation (Formulas).
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.
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 clients really feel happy because we like to work for clients to give them good services and quality in works. You just message us And feel free to discuss your requirements after that we start your task. We don't keep clients in waiting. Thank you for spending your valuable time for reading proposal. We are looking forward to contribute to your success. You dream it. We will be with you all the way to complete our project as needed
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 & Regards
Pr technology
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.
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.