very simple mysql look up and update values
€6-12 EUR / ชั่วโมง
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
หมายเลขโปรเจค: #4449985
เกี่ยวกับโปรเจกต์
freelancer freelancer 18 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ €7/ชั่วโมง
Hi. I've been using MySQL for about ten years. I could have this done for you quickly. It can be done easily with just an SQL query. Thanks.
Sure, It is a simple MySQL query, I can give the query to you right now. Kindly grant me the opportunity to work with you.
Senior Software Architects with great experience in Database Management Systems. Please check private message.
Six years experience in Database with fortune 500 company. Ensure best quality and low turnaround time.
I have done training in mysql in a company(whose name i don't want to disclaim). and i am fresher to freelancer:) so waiting for an opportunity. I think this will be a good one to start. :)
