Results 1 to 11 of 11
Sep 18, 2013, 01:49 #1
- Join Date
- Mar 2011
- Manchester, UK
- 0 Post(s)
- 0 Thread(s)
Delete Duplicates From All Tables?
I have 4 tables within the same database. All of them have a field called 'email' in them. How do i go about doing a Query which will Delete the row of data if the same 'email' is found in another Table leaving just the 1 record? I dont know if this makes it any easier for you but each row of data has an ID number (note it wont be the same ID number in the other tables for the same 'email' row, its just an Auto Increment i added before importing the data).
Another thing i need to make you aware of is that theres nearly 10 million records between the 4 tables. Is there anything i should do to speed the process up?
If anyone could help me that would be great.
MikeYou're Help Does Not Go Unnoticed, I have So Far Donated £25 GBP
To Cancer Research UK As A Thank You To All The SitePoint
Members That Have Helped Me In The PHP Forum Thank You!