[MySQL] How to import a column from db1.table to db2.table

[kh99]

Originally Posted by kevin.kool

It's Success. But it's look like it doesn't get thanked amount from database1. The thanked amount is from "write" db and being rewrite again with userid+1.

[S]If you still have the old table in another database, you could try adding the database to the table names of the first query, like[/S]

Edit: never mind, I hadn't looked at the php file linked above where Disasterpiece had already handled the second database.

BTW, I think this could be done via query something like:

UPDATE db1.vb_user as old LEFT JOIN db2.vb4_user as new ON (old.userid = new.userid + 1)
SET new.thanked = old.thanked

(But I haven't tested that exact query). That of course assumes that you've already created a "thanked" column in the new db....and that the dbs are on the same server.