Kapalı

very simple mysql look up and update values

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

Beceriler: MySQL

Daha fazlasını görün: 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

İşveren Hakkında:
( 10 değerlendirme ) Dublin, Ireland

Proje NO: #4449985

19 freelancer bu iş için ortalamada 8€/saat teklif veriyor

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 / saat
(36 Değerlendirme)
4.3
kchg

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

12€ EUR / saat
(21 Değerlendirme)
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 / saat
(11 Değerlendirme)
3.9
gatiworks

I have excellent experience working with import export with MySQL database

9€ EUR / saat
(18 Değerlendirme)
3.7
code827562

Hi, I am interested. Thanks!

9€ EUR / saat
(6 Değerlendirme)
3.5
Creativeartbd

Let's start it and get it done fast.

6€ EUR / saat
(6 Değerlendirme)
3.4
bestphpjobs

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

6€ EUR / saat
(13 Değerlendirme)
3.4
darkerbg

I have the query ready

9€ EUR / saat
(1 Değerlendirme)
2.4
oaliosl

Hi, ready to start. waiting for response. Thanks

11€ EUR / saat
(1 Değerlendirme)
0.6
mahshook786

i can do this perfectly

6€ EUR / saat
(0 Değerlendirme)
0.0
C0RETECHIES

Already Completed.Please check your PMB.

6€ EUR / saat
(0 Değerlendirme)
0.0
Devdutt8877

please try it'll work

9€ EUR / saat
(0 Değerlendirme)
0.0
muralidgl

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

7€ EUR / saat
(0 Değerlendirme)
0.0
kcauchi

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

9€ EUR / saat
(0 Değerlendirme)
0.0
webdeveloper38

Seems simple! Lets get started! Thanks,Nisha

6€ EUR / saat
(0 Değerlendirme)
0.0
ppolydoras

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

6€ EUR / saat
(0 Değerlendirme)
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 / saat
(0 Değerlendirme)
0.0
poojakalra

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

6€ EUR / saat
(0 Değerlendirme)
0.0
chinbochen

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

6€ EUR / saat
(0 Değerlendirme)
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 / saat
(0 Değerlendirme)
0.0