How to export this from mySQL using SQL or PHP?

Question

I have this table below in mySQL with thousands of rows. If you notice 1, 2, 3 token are the same but the 3rd token has a different IP.

token                                  ip
4aa1813449465a6ec1fc82e0ef09e2b1       2.17.58.126
4aa1813449465a6ec1fc82e0ef09e2b1       2.17.58.126
4aa1813449465a6ec1fc82e0ef09e2b1       94.71.213.235
d41d8cd98f00b204e9800998ecf8427e       63.24.23.129

My question is how can I end up with removing all duplicates rows ( token + ip ) ending with this

token                                  ip
4aa1813449465a6ec1fc82e0ef09e2b1       2.17.58.126
4aa1813449465a6ec1fc82e0ef09e2b1       94.71.213.235
d41d8cd98f00b204e9800998ecf8427e       63.24.23.129

Do you want to select or delete?

juergen d
– juergen d

2014-08-30 14:00:04 +00:00
Commented Aug 30, 2014 at 14:00 — juergen d
– juergen d, Commented Aug 30, 2014 at 14:00

Niels Keurentjes · Accepted Answer · 2014-08-30 14:00:44Z

1

SELECT DISTINCT * FROM <table>;

To create a new cleaned up table:

SELECT DISTINCT * INTO <newtable> FROM <table>;

To clean up the table inline you would need to have a unique primary key, you cannot 'deduplicate' completely identical rows since you cannot target the individual duplicates.

answered Aug 30, 2014 at 14:00

Niels Keurentjes

42.1k9 gold badges103 silver badges138 bronze badges

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

2 Comments

EnexoOnoma Over a year ago

Will this work if instead of the * write token, ip ?

Niels Keurentjes Over a year ago

If those are the only 2 fields it's identical - * just means 'all available fields'.

Collectives™ on Stack Overflow

How to export this from mySQL using SQL or PHP?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related