Remove all the duplicate values in MYSQL table

Question

mysql format :

        jcid_no           die_no          qty
       jcid-085951         12345            2
       jcid-085951         12345            2

Friends I've a table format as the above , I'll be continuously inserting the values into the table but my requirement is I can insert n times same number of same jcid_no and die_no but not on the same row .

Valid example:

        jcid_no           die_no          qty
       jcid-085951         12345            2
       jcid-085951         54321            2


        jcid_no           die_no          qty
       jcid-085951         12345            2
       jcid-984301         12345            2

Same jcid_no different die_no and same die_no different jcid_no is ok but as if now my table got cluttered by have same table values multiple times my requirement is first I have to delete all the duplicate values that has been already inserted (i.e)

Wrong Format :

        jcid_no           die_no          qty
       jcid-085951         12345            2
       jcid-085951         12345            2

and the second thing is preventing this duplication for further enter , I use PHP as my front end .

select distinct into temp table. Delete. Copy back.

jarlh
– jarlh

2015-11-04 11:15:40 +00:00
Commented Nov 4, 2015 at 11:15 — jarlh
– jarlh, Commented Nov 4, 2015 at 11:15

Community · Accepted Answer · 2017-05-23 11:51:57Z

1

To avoid further faulty values try using combined primary key like

PRIMARY KEY (jcid_no, die_no)

To delete double values try it with self join delete.

edited May 23, 2017 at 11:51

CommunityBot

11 silver badge

answered Nov 4, 2015 at 10:54

Daniel Walter

8256 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Remove all the duplicate values in MYSQL table

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related