Closed

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?

Skills: MySQL, PHP, Software Architecture, Database Programming, Java

See more: 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

About the Employer:
( 11 reviews ) Clydebank, United Kingdom

Project ID: #27481313

24 freelancers are bidding on average $24 for this job

sumon355

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

$10 USD in 0 days
(167 Reviews)
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 More

$30 USD in 1 day
(222 Reviews)
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 in 1 day
(149 Reviews)
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 More

$30 USD in 1 day
(25 Reviews)
5.8
PATechnology

Hi, I am interested in the task. Thanks

$30 USD in 1 day
(111 Reviews)
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 More

$30 USD in 2 days
(106 Reviews)
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 More

$80 USD in 2 days
(11 Reviews)
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 in 22 days
(4 Reviews)
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 in 1 day
(28 Reviews)
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 More

$25 USD in 1 day
(26 Reviews)
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] More

$20 USD in 7 days
(6 Reviews)
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 More

$15 USD in 7 days
(5 Reviews)
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 More

$18 USD in 1 day
(3 Reviews)
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 More

$35 USD in 1 day
(11 Reviews)
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 More

$30 USD in 1 day
(3 Reviews)
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 More

$30 USD in 4 days
(1 Review)
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 in 1 day
(0 Reviews)
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 More

$10 USD in 7 days
(0 Reviews)
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 in 7 days
(0 Reviews)
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 More

$25 USD in 7 days
(0 Reviews)
0.0