Find Jobs
Hire Freelancers

Compare Database 2 tables and put missing records from 1 to other

$15-24 USD

In Progress
Posted over 8 years ago

$15-24 USD

Paid on delivery
The data now is csv. You need to write a mysql script to do this the fastest way I got 83k of data records that needs to be compared to a master DB of 2m records. The 83k is missing 2 columns -- category and subcategory. 50k of the 83 k has a unique ID. The other 30k needs to be matched by the business name.
Project ID: 9162649

About the project

23 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
23 freelancers are bidding on average $45 USD for this job
User Avatar
A proposal has not yet been provided
$45 USD in 3 days
5.0 (140 reviews)
6.4
6.4
User Avatar
Dear Sir we are capable of performing the required task perfectly with accuracy, please let us know if you want to clarify in details.. if you want us to share our skill and previous work please initiate the chat by replying.. hope to hear you soon.. Thanks & Regards Moumita
$123 USD in 9 days
4.9 (78 reviews)
6.6
6.6
User Avatar
Can complete this in a few hours. I can start right now and deliver quickly. Please let me know if you have any questions. Thanks, Josh O.
$30 USD in 0 day
4.9 (44 reviews)
6.0
6.0
User Avatar
Hi I am very interested to work on your project. I have 10 years of experience in software development (more than 1000 projects done) and few can be seen on freelancer.com Let's start by giving me all details
$100 USD in 8 days
5.0 (48 reviews)
5.8
5.8
User Avatar
tell me in what format you need the output. CSV as the input was fine?
$55 USD in 0 day
5.0 (9 reviews)
4.9
4.9
User Avatar
A proposal has not yet been provided
$20 USD in 1 day
4.8 (42 reviews)
5.0
5.0
User Avatar
Hello Sir / Madam , i am interested in this project and i can do this for you Please give me a chance :) i have vast experience in php/mysql, CodeIgnator , Object Oriented Programming :) thanks
$60 USD in 3 days
5.0 (10 reviews)
3.7
3.7
User Avatar
A proposal has not yet been provided
$30 USD in 2 days
5.0 (2 reviews)
2.6
2.6
User Avatar
Hi There,, I had read the description and requirements you provided in project and I am 100% sure that I can do each and every of that requirement easily.. I assure you that You will not regret your choice of choosing me at the end of the project. Looking forward for your positive response and I am hoping to start on this project.. Thanks alot... Have a nice time.. Take care...
$30 USD in 3 days
4.9 (3 reviews)
2.4
2.4
User Avatar
A proposal has not yet been provided
$24 USD in 2 days
3.0 (2 reviews)
1.0
1.0
User Avatar
Hi, I’m dedicated professional Web and Desktop Programmer & Developer and also Team leader of my company. I have been working with challenge and hope to improve future plan with good network every client. If any client want to get more faster job services with save time I am ready to work. I can ensure that I’ll complete each instruction within time frame even more faster. I am available everyday to work more than 12 hours. I can ensure that I'll complete each instruction within time limit with daily update on server. I am ready to work and I hope I'll get permit to prove my experience. Thank you
$24 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello dear, I am Computer Science graduate. I am basically working as web developer and web designer in a firm and often do freelancing as part time. I am willing to do your task. Let's come in chat for detail. Thankyou.
$18 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am experienced on managing csv/json data into database. 3 days is for staid. Maybe finish in one day if the csv data is in well-formatted.
$24 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have some experience in sql quires and know how they work . please feel free to contact me thanks.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, this shouldn't be a problem as I do a lot of work like this. Thanks, Adam
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
You can contact with me at any moment to discuss your task. You can contact with me at any moment to discuss your task.
$100 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
SQL DBA with 5 + years of experience. I have expertise in SQL performance tuning. I can get this done in 3 hours from the time I'm awarded the project. Need Remote access to server or share screen via team viewer
$157 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, if you can give me the details of the record I can turn this around for you in one day. I am in the boston, MA area of the US and am able to discuss over chat,text or phone. This is a really low bid because I am trying to build my freelance profile. thank you, -bernie
$24 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Having worked as a Database Developer and Administrator, gives me the edge to complete the requirements on time and as per the desired quality.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, My work motto is to provide quality work to my client. I have read and understood your requirements completely and as I have expertise level experience in the same, I think I am right for this job. Following is my industry experience. Please have a look. I have focused experience in IT industry in various fields like banking, insurance, financial, retail and manufacturing. Experienced in relational database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management. Comprehensive experience as Oracle DBA, proficient in Oracle 9i/10g/11g/12c, MySQL 5.x Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Tuning Oracle 12c/11g/10g/9i, MySQL 5.x on AWS, Unix and Windows NT platform. Thorough understanding of the Oracle data dictionary. Have good experience in AWS, UNIX administration, Shell scripting. We can discuss further. Please do let me your thoughts. Thanks, Juzer
$21 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Boca Raton, United States
4.9
14
Payment method verified
Member since Sep 27, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.