Closed

very simple mysql look up and update values

This project received 20 bids from talented freelancers with an average bid price of €8 EUR / hour.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
€6 - €12 EUR / hour
Total Bids
20
Project Description

READ THIS IN FULL BEFORE BIDDING, EVERYTHING YOU NEED IS IN THIS TEXT!!!

I WILL PAY ONLY WHEN CODE IS CONFIRMED WORKING CORRECTLY

After a simple mysql query, I only want the supplied MYSQL code, no access to the server will be given

I'm looking to update certain fields in mysql,
I have exported the mysql to excel,
Had my client edit the values required,
And updated the data into a temp table in the same database.
I'm looking for mysql command to perform the update?


The Database is "totalpd_tcs2013"
The Source Table is "cscart_product_options_inventory_temp"
The Target is
"cscart_product_options_inventory"

There are 3 fields in the source:
combination
product_code
location

We need "combination" as the key and update the relevant values from "product_code" and "location" to the correct entry.
There are other values in that table that must be left alone, eg product_id, amount, etc
We're looking for the source MYSQL to execute

Quick response will lead to further work down the road.

Thanks

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