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

[kevin.kool]

I've down from vb4 to vb3, and there is no table prefix on 2 databases, i have full rights to modify them both.

I've just ran the query and there is an error:

Error

SQL query:

UPDATE vb4forum.user AS old LEFT JOIN vb3forum.user AS new ON ( old.userid = new.userid +1 ) ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1