In Progress

update values in mysql database

This is a 2 part job

Part a

I have database which has a table for businesses.

A table for locations, each location having and ID.

In the business table, instead of recording the location name for city, state and country, the location ID is stored.

You need to

1. make a copy of the business table

2. Do a find and replace of the location ids, with the location names

Part b

The same database has a table for articles, and a table for images.

The images table, link the images to the article by the article id.

I need you to

i. Make a copy of the article table.

ii. Add a new column "new iamges"

iii. run a script that will bring in the image names, from the image table that corresponds to the correct article id and populate the "new Images" column with the corrrect image name.

Its a BIG database (1 gig) so you will need to download a zip file of the database, work on it locally and reload it.

Skills: MySQL

See more: mysql update values, update values mysql, values, values mysql, work values, mysql city state database, job values, country state and city database mysql, database copy script, script update database mysql, mysql populate table, reload file, update database mysql, populate database, mysql update database, update image database, city state zip database, state country database script, mysql update table, country city database, copy zip image file, image database work, mysql replace script, update image mysql, state city mysql

About the Employer:
( 72 reviews ) Berlin, Germany

Project ID: #4697172

Awarded to:

xpreflect

Hello, sir! We would like to take over your task. We have over five years of experience in managing databases. We promise professionalism and the shortest execution time.

$50 USD in 3 days
(0 Reviews)
0.0

16 freelancers are bidding on average $103 for this job

GetReal

Freelance Professional!!!

$147 USD in 3 days
(278 Reviews)
7.1
coolguyinus2004

PHP/MYSQL expert. Some issue there you need to look at PMB.

$257 USD in 3 days
(165 Reviews)
6.9
samzinc

kindly check your pmb

$105 USD in 2 days
(21 Reviews)
4.9
allroundexperts

Lets start right now !

$80 USD in 2 days
(42 Reviews)
4.8
briandebottari

I can help you with this. I can start working right away if you accept my bid.

$111 USD in 0 days
(3 Reviews)
3.9
weblaunch

lets start the work......

$147 USD in 2 days
(4 Reviews)
3.1
quatroo

I can help you with your project.

$55 USD in 1 day
(2 Reviews)
2.6
nexus7x

Hi, I can do this quick!

$60 USD in 3 days
(0 Reviews)
0.0
thenomader

I have 4 years experience with Web development and database management, I am ready to start righ now so let's get it done right away and I mean RIGHT AWAY !! Looking forward to hear from you soon - GOD Bless You.

$77 USD in 3 days
(0 Reviews)
1.2
srini286

Sounds simple thing can do this easily

$30 USD in 3 days
(0 Reviews)
0.0
GishanAbeysinghe

Consider and done

$45 USD in 3 days
(0 Reviews)
0.0
tikumishra

Downloading 1GiG DB locally would be very time [url removed, login to view] check my PMB for a solution.

$111 USD in 1 day
(0 Reviews)
0.0
dagolin

I have been working on MYSQL for years and can handle it ASAP .

$155 USD in 3 days
(0 Reviews)
0.0
kfaizan

Hi, I Would Be Happy ! To Help.. in shaa Allah Regards Faizan Khan ... my previous Work is [url removed, login to view]

$50 USD in 2 days
(0 Reviews)
0.0
Meyson

Accept my bid, and I will start work right now.

$111 USD in 0 days
(0 Reviews)
0.0
joemarecaro

I am new to freelancer, but has more than 2 years of extensive experience working on databases and developing websites. Making complex queries for mass record updates and reports generations. So you may consider me for More

$166 USD in 3 days
(0 Reviews)
0.0