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 In3 days
This is a 2 part job
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
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.
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online