Suljettu

mysql data entry prevent duplicates

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?

Taidot: MySQL, PHP, tietojärjestelmäarkkitehtuuri, Tietokantaohjelmointi, Java

Näytä lisää: how to avoid inserting duplicate records in mysql using java, how to avoid inserting duplicate records in sql, how to avoid inserting duplicate records in mysql, how to avoid inserting duplicate records in mysql using php, mysql on duplicate key ignore, mysql avoid duplicate entry, mysql select without duplicates, how to avoid duplicate records in sql insert query, mysql data entry, jquery ajax json php mysql data entry example, developing data entry form mysql, jsp java mysql data entry page example, website data entry mysql, simple mysql data entry script, mysql data entry script, data entry restriction excel duplicates, php mysql avoiding duplicates data entry, Hi I am a fast and experience data entry operator and I’m very interested in your job post involving data scrapping. I have g

Tietoa työnantajasta:
( 11 arvostelua ) Clydebank, United Kingdom

Projektin tunnus: #27481313

24 freelanceria on tarjonnut keskimäärin 24$ tähän työhön

sumon355

Hello, Did you just block me from the chat? What's wrong? You were trying get free consultation? Too unprofessional!

$10 USD 0 päivässä
(167 arvostelua)
7.0
ineedWorkJob

Greetings sir, I have read your project details and i can help you with mysql duplicates issue. Sir, i can deliver this project sooner than you expect and will be over your satisfaction level. Please continue Lisää

$30 USD 1 päivässä
(222 arvostelua)
7.1
crazynightwalker

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 1 päivässä
(149 arvostelua)
6.1
jadejarajdeep

Hi There Thank you for reading my application. its depends using which tool you are insert the data is it any webpage developed to insert this data. or your are insert with some other database tool. kindly share so Lisää

$30 USD 1 päivässä
(25 arvostelua)
5.8
PATechnology

Hi, I am interested in the task. Thanks

$30 USD 1 päivässä
(111 arvostelua)
5.9
TeamDPS

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 s Lisää

$30 USD 2 päivässä
(106 arvostelua)
5.6
arnoldb

Hi, I hope you are doing well. I am a full stack developer from Poland with 8 years of experience in mobile app and web technologies. I have go Lisää

$80 USD 2 päivässä
(11 arvostelua)
5.4
vw330189vw

Hello, I have knowledge in SQL language and MySQL. There are a few options to fix the problem you have. Regards

$22 USD 22 päivässä
(4 arvostelua)
4.8
mepsd

Hello sir i am SQL expert this is 5 mins work for me. let us connect to start working Thanks Paras Suthar

$10 USD 1 päivässä
(28 arvostelua)
4.7
Hada36

Hello, Thank you very much post your project. I am very much interested on your [login to view URL] my Experience and Expertise I believe and very confident that I will be able to handle your project efficiently and effect Lisää

$25 USD 1 päivässä
(26 arvostelua)
4.5
bhaveshkeshrani

Thanks for posting this project. I have experience working on the database since long. I can surely get this issue solve. please feel free to contact me. Please visit my website for more details: [login to view URL] Lisää

$20 USD 7 päivässä
(6 arvostelua)
3.9
awaissheikh151

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 Lisää

$15 USD 7 päivässä
(5 arvostelua)
3.6
jithu41343

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 withi Lisää

$18 USD 1 päivässä
(3 arvostelua)
3.1
SqlDevelopment

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 Lisää

$35 USD 1 päivässä
(11 arvostelua)
3.1
muhammadawais083

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 i Lisää

$30 USD 1 päivässä
(3 arvostelua)
1.2
abmjamil23

Hi I can add a php script that will handle with duplicate data and strongly feel that will work for you. I am an experienced software engineer working for almost twenty years. I am flexible, adaptable and able to man Lisää

$30 USD 4 päivässä
(1 arvostelu)
1.0
yunier0525

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 1 päivässä
(0 arvostelua)
0.0
SSolution1

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 Applicatio Lisää

$10 USD 7 päivässä
(0 arvostelua)
0.0
RTYSDAL

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 7 päivässä
(0 arvostelua)
0.0
vw7585806vw

HI I go through the description I can assure that i can be complete the project and solve your issue asap. Hands on developing windows based application,Web application with backend [login to view URL] on experience in devel Lisää

$25 USD 7 päivässä
(0 arvostelua)
0.0