Ash wrote:
INSERT INTO List1 (name, email, unsubbed) (SELECT name, email, 'N',
FROM List2)
If you're worried about duplicates, that's pretty simple to avoid,
too. Just say the word.
Yah, duplicates too. :D
Ash
INSERT INTO List1 (name, email, unsubbed) (SELECT name, email, 'N' FROM
List2 LEFT JOIN List1 ON List2.email = List1.email WHERE List1.email IS
NULL)
That should prevent it from inserting any email address from List2
that's already in List1.
_______________________________________________
UPHPU mailing list
[email protected]
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net
