well, technically that works, but if you are merging a banned user into a non-banned one you might OR the ban state?
same idea for the other ones...
so YES, delete removes all traces of former, but doesn't truly then MERGE
you might think of UPDATE queries and REPLACE INTO queries if you truly want to merge..
in the end, your queries are good for a removal of the former self though
