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

[kevin.kool]

Originally Posted by Disasterpiece

hum, well it should oO

did you re-check the database credentials?

Yes, i've recheck the column after each run.

Originally Posted by kh99

[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.

Could you rewrite the query with those extractly db name, table name and column name as i listed above?