How Mass edit Post owner to a different user?

Question

I'd like to bulk assign all activity(questions/answers/comments) of a particular user to a different user ID, through PHPMyadmin?  I know its easy, but im not good with SQL.

Thanks for any help, in advance.

Answer 1

just try the following

update qa_posts set userid="to a different user ID"  where userid="particular user ID";

you need to update name and other information if necessary.

Comments

Thanks, that worked just fine. :)

---

You'll also want to go to the Admin > Stats page and click the "Recount posts" button to update the user stats.

---

Oh, i just used "recalculate points" instead. Will it work?

Also, please reply to the PM i sent if you have time. Thanks.

---

Can you please check the PM when you have time. @Scott Thanks.