[MySQL] How to import a column from db1.table to db2.table
Hello,
I've just downgraded my forum from vb4 to vb3, and would like to keep the "thanked" amount from old db. I looked into the old db and notice that "thanked" is a column in "user" table.
So i would like to ask how can i move (or copy) that column from old database into the table of the new database?
Also, is there anyway to plus 1 value in the "userid" field (of that column)? Because of i've used ImpEx and it's created a new admin with userid = 1, then my old admin account has userid = 2.
Thank you.
|