very simple mysql look up and update values

Closed

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

Skills: MySQL

See more: temp data entry, mysql query, djstevie84, data entry temp, client update required, access query excel, excel quick access, mysql excel query, data entry excel mysql, mysql source excel, mysql lead, mysql update values, excel query mysql, update values mysql, excel update mysql, look target, look table excel, query text mysql, excel database update, excel table mysql, mysql update table, bidding mysql code, excel data entry mysql, quick temp, database update required

Project ID: #4449985

19 freelancers are bidding on average €8/hour for this job

drysder

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.

€8 EUR / hour
(36 Reviews)
4.3
kchg

Hello I'm interested with your project. I'll do it for you. Regards.

€12 EUR / hour
(21 Reviews)
4.1
farhaoui

HI, READY TO START WORK. LETS START AND FINISH IT ASAP. I HAVE 8 YEARS OF EXPERIENCE IN WEB DEVELOPMENT FIELD ( PHP, MYSQL, AJAX, JQUERY, HTML, CSS... ). THANK YOU !!

€8 EUR / hour
(11 Reviews)
3.9
gatiworks

I have excellent experience working with import export with MySQL database

€9 EUR / hour
(18 Reviews)
3.7
code827562

Hi, I am interested. Thanks!

€9 EUR / hour
(6 Reviews)
3.5
Creativeartbd

Let's start it and get it done fast.

€6 EUR / hour
(6 Reviews)
3.4
bestphpjobs

HI, I HAVE SQL READY AND ALREADY SENT YOU ON PMB PLEASE CHECK IT :)

€6 EUR / hour
(13 Reviews)
3.4
darkerbg

I have the query ready

€9 EUR / hour
(1 Review)
2.4
oaliosl

Hi, ready to start. waiting for response. Thanks

€11 EUR / hour
(1 Review)
0.6
C0RETECHIES

Already Completed.Please check your PMB.

€6 EUR / hour
(0 Reviews)
0.0
thindo

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.

€6 EUR / hour
(0 Reviews)
0.0
Devdutt8877

please try it'll work

€9 EUR / hour
(0 Reviews)
0.0
muralidgl

it's simple one hope u will satisfied for my work

€7 EUR / hour
(0 Reviews)
0.0
ppolydoras

Senior Software Architects with great experience in Database Management Systems. Please check private message.

€6 EUR / hour
(0 Reviews)
0.0
chinbochen

Hello sir, I'm glad to do this for you. Thanks.

€6 EUR / hour
(0 Reviews)
0.0
webdeveloper38

Seems simple! Lets get started! Thanks,Nisha

€6 EUR / hour
(0 Reviews)
0.0
poojakalra

Six years experience in Database with fortune 500 company. Ensure best quality and low turnaround time.

€6 EUR / hour
(0 Reviews)
0.0
anurag017012

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. :)

€9 EUR / hour
(0 Reviews)
0.0
mahshook786

i can do this perfectly

€6 EUR / hour
(0 Reviews)
0.0
kcauchi

I have lots of experience in this area. I have been working on databases since 2007.

€9 EUR / hour
(0 Reviews)
0.0