hi, i'm trying to add cities and regions of some counties in the middle east in a my website database from another file that has the same tables (country,regions,cities) but different colmns and format.
you have to put the city# and then the city name in the fallowing format:
(511903, 782777, 'Dasman - دسمان', 'dasman', 'KW', 1),
(511904, 782777, 'Sharq - شرق', 'sharq', 'KW', 1),
also regions and countries need to be added in the same way:
(782777, 'KW', 'Kuwait city - مدينة الكويت', 'kuwait-city', 1),
(782778, 'KW', 'Hawalli - حولي', 'hawalli', 1),
i already did Lebanon and Kuwait.
i need the fallowing counties also:
Bahrain - البحرين
Egypt - مصر
Jordan - الآردن
Oman - عمان
Qatar - قطر
Saudia Arabia - السعودية
Syria - سوريا
UAE - الإمارات
Yemen - اليمن
Iraq - العراق
Palestine - فلسطين
Algeria - الجزائر
Morocco - المغرب
Libya - ليبيا
Tunisia - تونس
Sudan - السودان
please note that you can get the cities from the sql file attached with the post.
you can convert both to an excel-sheet format using this method:
[login to view URL]
and then export back to mysql using the same tool.
(estimated work time of the task 2 hours)
attached is the file that needs to be updated with the lists that already have been entered.
also note that if there are any errors you should do the debugging.
please let me know if more information is needed as i will be in contact with you.
Kind Regards,
Abdulrahman
Hello,
my name is Muhammad Salah, I'm a database Admin from Egypt I can help you to insert the cities into your website database please contact me on chat to talk in more details
Thanks
We are an exceptionally competent team with an average experience of 10+ years in various fields of Information Technology. Our DB architects and administrators are very well versed with many kind of DB servers like Oracle,MS SQL Server,MySQL,Postgres etc. Price quoted is ballpark. Please share your availability to discuss about your project.
Hello Sir,
I am good in country , state and city management in database. I have 12 year experience in PHP , MySql and MVC framework.
I will provide good and quick service your requirement without any bug.
Please come at chat so we can quickly start and complete task in just few hours.
Thanks,
Hello,
I am mysql expert and have great attention to detail. Will arrange your data as required and debug if there are issues with it.
* will not translate to arabic where translation is missing as i have almost no knowledge of arabic and would not be able to confirm correctness.
Hi There,
I have done similar projects in my recent company and the requirement seems familiar to me. I am okay to negotiate the bid value.
I shall be waiting to start the journey with you at the earliest.
BEst Regards,
Ravi Teja
Working hours 10:00AM to 9:00PM (IST)