Find Jobs
Hire Freelancers

Delete duplicate mySQL data records

$15-25 USD / hour

Closed
Posted over 3 years ago

$15-25 USD / hour

You will be given a mySQL database with many duplicate records. There are over 128,000 lines. We estimate that almost half of these lines are duplicates. You will need to find and delete all duplicate records from the mySQL database table and then provide a clean database with no duplicate records.
Project ID: 28396043

About the project

50 proposals
Remote project
Active 3 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
50 freelancers are bidding on average $20 USD/hour for this job
User Avatar
Hello, I have a lot of experience with this task Please have a look at my Portfolio and client's feedback here for the projects completed. https://www.freelancer.com/u/minhhoangduc.html?pvpReviewLink=true Please let me help you do it. Best Regards, Minh H
$20 USD in 10 days
4.9 (520 reviews)
8.4
8.4
User Avatar
Hello, As an expert in MySQL, I am very much interested to clean the duplicate data. Are the lines in the same table? May I take a quick look on the data? Let's discuss more in detail. Thanks
$19 USD in 40 days
5.0 (177 reviews)
7.3
7.3
User Avatar
Hi There: Hope this note finds you in great spirits. We are a team of IT professionals mentored by very experienced leadership. We offer solutions on WEB and Mobile technologies. Please visit our company site www.kennedia.net. We have in house UI/UX and the Testing team performing Manual, Automation and Performance testing. Look forward to hearing from you!! - Thanks, Raman
$15 USD in 40 days
5.0 (18 reviews)
7.0
7.0
User Avatar
Hi, RalphGarcia How are you? I am very good at PHP, MySQL, I can remove all duplicated data in the DB. Please contact me to start now. Hope to be working with you. Regards.
$20 USD in 40 days
5.0 (39 reviews)
6.3
6.3
User Avatar
Nice to meet you on freelancer. My name is Da Zhang. I am a python programmer. Your project looks very simple to do. - create a new table with the same structure. - query out all 128K lines. - compare necessary fields (for example, there 10 columns in the table, 5 of them are the same, then we think they are duplicates, of course, we can also complete all 10 columns) - save unique result into another list. - insert the result into the new table we created. - You can then verify the old data and the new data. - if the new data is good. You have 2 options to do: & - delete the old table, rename the new table back to the old table name & - delete all data from old table, copy the data to old table, delete the new table. This is really not hard. I make my weekly limit 5 hours. Let's talk! Thank you very much.
$20 USD in 5 days
5.0 (45 reviews)
6.3
6.3
User Avatar
Hello Greetings, I have gone throught your project placement to delete all duplicate records from the mySQL database table and it matches my expertise. I am ahsan azhar, full stack developer with a working experience of 5+ years. I design and develop professional, modern, user friendly and SEO compatible website. I look forward to your response.
$15 USD in 40 days
5.0 (31 reviews)
5.4
5.4
User Avatar
Hello I can do this task within short time. I need access and I can start. rest we can discuss on chat. thanks for your time.
$22 USD in 20 days
5.0 (23 reviews)
5.6
5.6
User Avatar
Hello, I am a mysql database expert and i can help you to remove duplicate and give u the clean database Please ping me for further discussion Thanks
$25 USD in 40 days
5.0 (22 reviews)
5.4
5.4
User Avatar
Hello, i'm an expert IT with more 15 years of experience in IT industry . i'm certified Cisco networking professional 300-100 and 300-115 and Linux professional lpi 101, 102 and red hat certified system administrator and VMware Certified Professional  4, 5,5.5 and Data Center and Microsoft System administrateur /Engineer  ranging from 2003 to 2012 .  i'll fix it in 2 hours
$50 USD in 2 days
4.9 (47 reviews)
5.3
5.3
User Avatar
I can efficiently assist you with removing of duplicate records because I am highly skilled database developer having more than 10 years of professional experience and advanced expertise in SQL development and troubleshooting.
$35 USD in 20 days
5.0 (40 reviews)
5.3
5.3
User Avatar
Hello there ! I can clean the data by deleting duplicate records efficiently as per your requirement. I've exceptional knowledge and experience in Database Development & Administration (5+ years); with Microsoft SQL Server (versions 2008-2019). Warm regards, Kundan
$25 USD in 40 days
5.0 (29 reviews)
4.9
4.9
User Avatar
Hello I am a database developer with more than 7 years experience working, so Ican easily clean your DB from duplicated records. It will take a few hours. Also I recommend to leave a copy of database if something went wrong. I would like to discuss more details about your project - number of tables,relations between them, etc . Looking forward to contact with you.
$15 USD in 20 days
5.0 (4 reviews)
4.2
4.2
User Avatar
Hi! I've read the description and I am very interested in your project. I am professional MySQL/postgres developer Let's discuss in chat
$20 USD in 20 days
4.5 (7 reviews)
4.7
4.7
User Avatar
Hi , I am Database developer with 10+ years of experience. Can you please provide the table details and i need access to the database. Please ping back to get started right away. I work for top MNC. Thank You Regards, Rishi R
$15 USD in 3 days
5.0 (13 reviews)
3.9
3.9
User Avatar
Hello, please provide your database and i delete all duplicates very fast. Regards, Oleksandr
$15 USD in 7 days
5.0 (13 reviews)
3.6
3.6
User Avatar
Hi there! you need to delete your MySQL duplicate data. i complete your task with best knowledge. i have 6 year of experience in web design and development. let we discuss on chat about your task. Thank you.
$15 USD in 3 days
5.0 (6 reviews)
3.1
3.1
User Avatar
Hello. I can help you perfectly in a short time. Please open chat with me and I'm ready. Thanks. Regards.
$35 USD in 40 days
5.0 (5 reviews)
3.3
3.3
User Avatar
Hello there, how are you? Please share the database file so I'd delete the duplicated data and share a clean one with you. Looking for the soonest reply from you. Thanks
$20 USD in 40 days
5.0 (4 reviews)
2.7
2.7
User Avatar
Hello sir. I just reviewed your job details and I think i can help you in this position. I am confident of high quality and quick timeline about this job. I will wait for your positive response. Jonas
$15 USD in 40 days
4.3 (4 reviews)
3.1
3.1
User Avatar
I have gone through the requirement, I am full time freelancer, I can do it. I CAN EASILY DO IT, CURRENTLY I AM WORKING ON MYSQL DATABASE ONLY. I have more than 16 yrs exp as Architect, Tech Lead, Developer in C#,Asp.net, MVC,.Net Core, VB.Net, XML, SQL server, MySQL, WebAPI, Xamarin, WPF, VBA and Android development The experience includes 4 yrs in remote working for overseas clients. Thanks
$20 USD in 40 days
3.6 (11 reviews)
3.9
3.9

About the client

Flag of UNITED STATES
Secaucus, United States
0.0
0
Member since Dec 1, 2020

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.