DELETING doubled users (MySQL)
- by vizzdoom
Hi
I have two tables. There are users informations from two sites:
p_users
p_users2
There are 3726 users in first and 13717 in second.
Some users in p_users2 are in p_users. I want merge this two tables to the one big table - but rows with same usernames can't be doubled.
How can I do this? I tried something like this:
DELETE FROM p_users2 WHERE…