update values in mysql database

This project was successfully completed by xpreflect for $50 USD in 3 days.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Completed In
3 days
Total Bids
Project Description

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.

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online