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
Project Budget€6 - €12 EUR / hour
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
There are 3 fields in the source:
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.
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