Find Jobs
Hire Freelancers

mysql data entry prevent duplicates

$10-30 USD

Closed
Posted over 3 years ago

$10-30 USD

Paid on delivery
hi im adding data to an existing table but it seems to insert all the data causing duplicates im using csv file how do i stop duplicates being inserted? e.g EXISTING DATA 1 GREEN 2 RED 3 BLUE and say i want to INSERT 4 BLACK 5 RED 6 BROWN then the end result should be (I WANT) 1 GREEN 2 RED 3 BLUE 4 BLACK 5 BROWN but is showing 1 GREEN 2 RED 3 BLUE 4 BLACK 5 RED 6 BROWN RED is getting inserted again how to stop this?
Project ID: 27481313

About the project

23 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
23 freelancers are bidding on average $25 USD for this job
User Avatar
Hello, Did you just block me from the chat? What's wrong? You were trying get free consultation? Too unprofessional!
$10 USD in 0 day
4.9 (173 reviews)
7.1
7.1
User Avatar
Hi, I am interested in the task. Thanks
$30 USD in 1 day
5.0 (114 reviews)
6.3
6.3
User Avatar
Hi, I think I have placed a bid on your other project as well - are these two the same or different projects? Let me know, I can help you with THE project or both of them, if these are actually different.
$30 USD in 1 day
4.9 (152 reviews)
6.2
6.2
User Avatar
hi am interested in your task. I read your description and found myself eligible to so this with my 6 years experience in development. my aim is to provide satisfied and quality work. for assurance of quality you can see my reviews. we can discuss more in chat
$30 USD in 2 days
5.0 (163 reviews)
6.1
6.1
User Avatar
I can offer for example a two ways. First. Make a trigger on a target table which will handle a duplicates. But I am not sure that before insert trigger is compatible with 'LOAD DATA INFILE' instruction. This should be additionally checked. Second. You can make an import to some staging table and then merge needed data to a target table.
$35 USD in 1 day
5.0 (33 reviews)
5.1
5.1
User Avatar
Hello, I have knowledge in SQL language and MySQL. There are a few options to fix the problem you have. Regards
$22 USD in 22 days
5.0 (5 reviews)
4.9
4.9
User Avatar
Hello sir i am SQL expert this is 5 mins work for me. let us connect to start working Thanks Paras Suthar
$10 USD in 1 day
4.7 (33 reviews)
4.8
4.8
User Avatar
Hi, The solution to you requirement is : 1)Create a unique index on unique column or columns you don't want to be duplicated. 2) Use ignore keyword in "load data infile command". Kindly let me know in case you require any assisstance.
$15 USD in 7 days
5.0 (7 reviews)
3.9
3.9
User Avatar
This can be fix very easily setting up constarints in MYSQL, so after that mysq table column won't accept duplicate value, if you try to insert same value you will get error constraint viloation. This can be down within few hours.
$18 USD in 1 day
5.0 (6 reviews)
3.6
3.6
User Avatar
Although I am relatively new to Freelancer, I have 25 years experience in Relational Databases. Message me and we can work out a solution to your problem in very short order.
$10 USD in 7 days
5.0 (1 review)
2.8
2.8
User Avatar
Hello there My name is Awais. I have expertise in hybrid app development and static websites. I have worked with php and mysql database too so after reviewing your project i think it is safe to say that i can deliver it to you in 1 or max 2 hours Hoping to see you in chat.
$30 USD in 1 day
5.0 (3 reviews)
1.2
1.2
User Avatar
I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I would love to work on your project. I view the job details extremely carefully and I am absolutely sure that I can do the project very well.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear respected sir We have read your details .. You need developer for your business.. We have more than 6 years of experience in software market ..Our expertise on 1- Responsive Website 2-SEO 3-Mobile Application 4-Content /Article Writing 5-Video Editing / videoGraphy 6-Graphic Design(logo banners,Flyers and much more) 7-UI/UX(Web and mobile designs) It would be our pleasure to work with you. Regards: SSolutions Thank you whatsApp:+ 9 2 3 4 7 3 7 7 6 4 7 6
$10 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am an experienced programmer with 6 years of professional experience, I can resolve your problem very quick, in about 5 minutes. Lets connect and start the work.
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Greeting!!! I reviewed your requirement, I am Oracle Certified Data Scientist,Analyst Professional having over 5+ years experience in Database development covering multiple technologies like oracle, mysql,sql plsql. I would like to work in this project, I will continue to work with you till you satisfy with my work. Thanks Kundlik R
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Clydebank, United Kingdom
4.8
13
Payment method verified
Member since Aug 17, 2010

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.