Completed

update values in a mysql database

This project was successfully completed by abhinay18 for $55 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$10 - $75 USD
Completed In
1 day
Total Bids
5
Project Description

I have a database with 3 tables that need data updating

Flex
clf _business
Relationships.

IN all three cases, the tables have a reference to an id in another table, and i need the name of the value brought in from the other table to replace the ID value in the inital table.

eg

IN clf_business table in COUNTRY Field ID = 182634749
IN Locations table, Id 182634749, Name = Australia

in clf_business table replace 182634749 with AUstralia

fields that need matching and replacing are

clf_business table
Country
State
City
Primary_Cat1

Flex Table
Add a new field "Flex_Image"
then match Flex id in table "Images" and populate the Flex_Image Field with the image url from Images table

Relationships.
Replace All Ids, with Names from Flex table

See video here [url removed, login to view]

Immediate start, i want this job finished today don't apply if you cant achieve this

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