mysql data entry prevent duplicates -- 2

Zaprto Objavljeno pred 3 letoma/leti Plačilo ob prevzemu
Zaprto Plačilo ob prevzemu

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 Arhitektura porgramske opreme MySQL Programiranje podatkovnih baz

ID projekta: #27482078

Več o projektu

29 predlogov Oddaljen projekt Aktiven pred 3 letoma/leti

29 freelancerjev ponuja v povprečju za $34 na tem delu

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 v 1 dnevu
(18 ocen)
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 v 1 dnevu
(21 ocen)
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 hour Več

$15 USD v 1 dnevu
(8 ocen)
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 v 1 dnevu
(13 ocen)
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 v 1 dnevu
(14 ocen)
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 v 7 dneh
(7 ocen)
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 v 1 dnevu
(8 ocen)
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. Več

$20 USD v 1 dnevu
(2 ocen)
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 Več

$20 USD v 7 dneh
(0 ocen)
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 can Več

$20 USD v 1 dnevu
(0 ocen)
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 v 1 dnevu
(0 ocen)
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 v 3 dneh
(0 ocen)
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 v 1 dnevu
(0 ocen)
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 v 3 dneh
(0 ocen)
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 v 1 dnevu
(0 ocen)
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, spa Več

$15 USD v 7 dneh
(0 ocen)
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 Več

$10 USD v 1 dnevu
(0 ocen)
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 v 5 dneh
(0 ocen)
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 v 1 dnevu
(0 ocen)
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 v 2 dneh
(0 ocen)
0.0