Osclass Database Country-City Entry

Cancelado Publicado hace 6 años Pagado a la entrega
Cancelado Pagado a la entrega

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:

[url removed, login to view]

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

Desarrollo de base de datos Programación de bases de datos MySQL SQL

Nº del proyecto: #16171377

Sobre el proyecto

20 propuestas Proyecto remoto Activo hace 6 años

20 freelancers están ofertando un promedio de $127 por este trabajo

msalahii

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

$155 USD en 1 día
(19 comentarios)
4.5
khannanav

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 Or Más

$155 USD en 3 días
(10 comentarios)
4.4
isyncevolution

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. Ple Más

$140 USD en 3 días
(9 comentarios)
3.5
PiasKumarDas

A proposal has not yet been provided

$45 USD en 3 días
(8 comentarios)
3.6
bnrajumnc

A proposal has not yet been provided

$222 USD en 10 días
(7 comentarios)
3.4
gayatriprods

We understand your requirements and would like to complete this task for you. Kindly get in touch to take this further.

$111 USD en 2 días
(0 comentarios)
0.0
hanif007india

I am an ERP Software Engineer. Good in Oracle, SQL.. Will do any back end work.. Woking as a ERP tachnical Support in UAE.

$155 USD en 1 día
(0 comentarios)
0.0
emanuelyoussef3

A proposal has not yet been provided

$30 USD en 1 día
(0 comentarios)
0.0
smitag1987

A proposal has not yet been provided

$155 USD en 3 días
(0 comentarios)
0.0
ootada

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 Más

$50 USD en 1 día
(0 comentarios)
0.0
Nawaf2020th

السلام عليكم استطيع ان اساعدك في مدن اليمن مع عليك سوى التواصل معي وسوف ازودك بكامل المتطلبات في وقت قياسي وشكراً

$155 USD en 3 días
(0 comentarios)
0.0
Ravi2052

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 R Más

$100 USD en 2 días
(0 comentarios)
0.0