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

[kevin.kool]

Got this:

Error: 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 '1' at line 1 (1) (id: 1)

[Disasterpiece]

Replace line 37 with this:

PHP Code:

    $q = "UPDATE ".$tableprefix2."user SET post_thanks_thanked_times = ".$row['post_thanks_thanked_times']." WHERE userid = ".(int)($row['userid']+1); 


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

[Disasterpiece]

hum, well it should oO

did you re-check the database credentials?

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

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

[kh99]

I think this is it:

UPDATE vb4forum.user as old LEFT JOIN vb3forum.user as new ON (old.userid = new.userid + 1)
SET new.post_thanks_thanked_times = old.post_thanks_thanked_times

This sets the vb3forum database from the vb4forum database. I think what I posted above assumed that you were going from vb3 to vb4 (at least as far as the table prefixes were concerned). Speaking of which, if you have table prefixes you need to add them.

[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

[kh99]

Hmm...well, both lines together are supposed to be all one query and it looks like you just have the first line there.

[kevin.kool]

yes, i've ran both of them together, but it shows up just 1 line for error.