mysql data entry prevent duplicates -- 2

$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?

PHP

Java

Software Architecture

MySQL

Database Programming

Project ID: 27482078

About the project

29 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

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

29 freelancers are bidding on average $34 USD for this job

@akhi1620

Hello , I would like to work on your project , I can solve this within couple of hours I already worked on this type of issues , I can prevent database duplicate entries. Thanks

$30 USD in 1 day

5.0

(18 reviews)

4.4

@uparejiya

Hi THERE, I can quickly help you out on the duplicate entry issue. Message me and lets finish this quickly. Thanks

$20 USD in 1 day

5.0

(21 reviews)

4.5

@sefakemal

Hi, I have pretty expertise on development of desktop apps with Vb.Net, java and python. Also I have written SQL sentences in the applications. Your issue looks simple and i think that it can be done maximum in 2 hours. Regards.

$15 USD in 1 day

5.0

(8 reviews)

4.1

@devharis007

Hi there, I am up for this job. I'll help you inserting unique data in just 30 mins max. Please share details via chat .

$20 USD in 1 day

5.0

(13 reviews)

3.7

@TAJMUL13

Yes. it's possible to avoid duplicate. i can start your work right now. If you didn't select anyone for this project, you may knock me for more discuss. Best regards, Tajmul

$15 USD in 1 day

4.9

(14 reviews)

3.8

@AmjadNiazi5

Hi there i can tell you how to do this, just come to my inbox. I am an expert PHP/MYSQL Developer. Thanks

$20 USD in 7 days

5.0

(7 reviews)

3.6

@Briggs00

Hi, I am able to fix this very easily. Please feel free to contact me with further details. Best Regards, Tinashe

$10 USD in 1 day

4.8

(8 reviews)

2.3

@jakerpro

Hi, sir. My name is Jaker, I have more than 5 years of experience in this field. I reviewed and understood your project details, and I would like to work with you on this MySQL problem. Please contact me to discuss it. Thanks.

$20 USD in 1 day

5.0

(2 reviews)

0.8

@gibranaakibshaik

I'm working in Cognizant Technology Solutions as Programmer Analyst And My technology is .Net . I have developed web applications from scratch and worked on various technologies. I'll be a good fit for this and you can have nice output too. Can start immediately. 40 hours / week. Looking forward to discussing. Thanks & Regards

$20 USD in 7 days

0.0

(0 reviews)

0.0

@velicko018

Hello, I have carefully read and understood your requirements for this job offer. I have 4+ years experience with Web Development and databases, and I know exactly what's your problem. I consider myself a perfect candidate for this job. I'm ready to start now. Please contact me via chat to discuss this position further. Thank you and have a nice day!

$20 USD in 1 day

0.0

(0 reviews)

0.0

@muhammadfaisal92

Hi i am expert in Sql queries , i have 6 year of experience in Database development , please share CSV file for more clarity .

$15 USD in 1 day

0.0

(0 reviews)

0.0

@hemantsatpute4

it solve your problem. i getting your point is it simple. i am Master in Computer your task is completed with a 3 days. i am work in backend MySql. In i am Work on Java in Project on Attendance management System.

$10 USD in 3 days

0.0

(0 reviews)

0.0

@nvn116

hi am interested in your task. I read the description and found myself eligible for the Task to do with my 6 years development experience. quality work and client satisfaction is my first moto.

$10 USD in 1 day

0.0

(0 reviews)

0.0

@chenlinfeng1024

Hi~ I am a experienced developer ,I can help you to solve this problem . would you like to tell me more details of this problem

$30 USD in 3 days

0.0

(0 reviews)

0.0

@Darshan1093

Hello i have checked your requirements and i can do it fluently if you give me chance. so please consider me for this job. Thanks.

$30 USD in 1 day

0.0

(0 reviews)

0.0

@sumitjavadev

Hi, I am a full stack java developer with 7 years of expericence . I have worked on web applications and web services. My key skills are java, j2ee, spring boot, spring mvc, html,react.js,node.js, mysql, mongodb, spark. I am looking forward for this opportunity. Regards Sumit Sharma 9899611169

$15 USD in 7 days

0.0

(0 reviews)

0.0

@rkundlik

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

@odelnorales

To Create a Java application which will be able to be connected to a SQL database validating duplicated colors. SQL: - Table: Colors *Columns: ID, Description

$35 USD in 5 days

0.0

(0 reviews)

0.0

@Oumair

Hello, I will tell you how you to remove/control this duplication. This rate for explanation to you what you need to do. If you want the code of solution then price is $25 Regards Umair

$10 USD in 1 day

0.0

(0 reviews)

0.0

@swainlina433

Hi! Here is a professional data inserter. Your project is awestruck. I will do it for you in within an hour of work. I am demanding 50 percent advance for this. So send quick to get quick.

$300 USD in 2 days