copy coloumn in MySQL from database to another db

[teokrata]

Hi!

 

I have a new problem

 

I need to copy a coloumn from a database to another database.

 

For example.. I hava a database, named dbase1 and there is a profile_field_data table and it's have a thanked coloumn. I want copy this to another database: dbase2 - profile_field_data - thanked coloumn.

 

Anybody can help me about this sql command?

 

 

Thanks in advance!!

[Lock Down]

Close but not quite. That way it overwrites all fields in the database.

 

If you are trying to copy just one field from one db to another you have to make sure the tables have equal number of rows and they matchexcept for not having the one field.

First create the thanked field in the second database using phpmyadmin.

 

Next run this sql command changing the database names to your databases. The profile_id may not exist but the real name should be the first column in the table...

 

UPDATE dbase2.profile_data set thanked = (select thanked from dbase1.profile_data where dbase2.profile_id = dbase1.profile_id )

Edited March 25, 2013 by Lock Down

[GradientWizzard]

Open cPanel > phpMyAdmin > Click the table you want, then click export, then import it into db2

[teokrata]

Thank you Lock! You are excellent!

 

I must changed the commands on the end, because you must say the database, where is the "profile_id", but everything other are perfect!

 

so the corrected command is this:

 

 

UPDATE dbase2.profile_data set thanked = (select thanked from dbase1.profile_data where dbase2.profile_data.profile_id = dbase1.profile_data.profile_id)

 

Thank you once more!!

Edited March 26, 2013 by teokrata

[GradientWizzard]

The question(s) in this support topic have been answered and the owner has been able to solve the problem. Because of this, the support topic has been closed and moved.If you have other questions, please open a new topic.