SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot eStudio's Avatar
    Join Date
    Dec 2001
    Location
    NE Texas
    Posts
    153
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Remove duplicate records?

    We have a client that has been using a different back-end for each site and we are going to integrate all sites to use the same new backend. We need to combine the email database but don't want duplicates.

    How can we remove duplicates?

    Thanks,
    Donna

  2. #2
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,200
    Mentioned
    105 Post(s)
    Tagged
    1 Thread(s)
    The easiest way would be:
    . . .[list=1][*]Load one table as the primary [*]Load the second into a holding table[*]Delete all records from the holding table that exist on the primary table[*]Insert all the records from the holding table to the primary table[*]Repeat steps 2-4 with the remaining tables. [/list=1]
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •