Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › Can you help me with my query to find duplicate records?

Can you help me with my query to find duplicate records?

Thread began 12/11/2022 7:03 am by jo271221 | Last modified 12/15/2022 12:08 pm by Ray Borduin | 146 views | 2 replies |

12/11/2022 7:03 am | #1 jo271221

Can you help me with my query to find duplicate records?

Query pasted in PM

12/12/2022 10:53 am | #2 Ray BorduinWebAssist

We will have to do this in a premier support ticket. I'm not confident I can do it remotely without being able to test my results while connected to your database.

Did this help? Tips are appreciated...

12/15/2022 8:21 am | #3 jo271221

I determined it was easiest to export to excel since 1. My column headings did not match, 2. Excel has a quick and easy remove duplicates.
After removing, it is easy to import to a temp table with the same structure of the table that will be the final destination.
The final destination table and the temp table should have a UNIQUE index defined to confirm we have -0- duplicates.
Then import from the temp table to the final table (column headings match now because of the import took care of that).

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.