Moving a field contents from Table B to Table A
Hi
I am wondering if i can move a field (with contents) from Table B to Table A. If so how can i do it?
Any advise ?? Thank you very much..
futhonguy
Junior Poster in Training
69 posts since Oct 2009
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0
Hi
I am wondering if i can move a field (with contents) from Table B to Table A. If so how can i do it?
Any advise ?? Thank you very much..
yes, you can do it with the PHP Myadmin utility directly.Look for some option in the database for copying the field or/and data to some other table in the same or different database.
You can create the same field manually, if there is just one and copy the data like -
UPDATE table1
INNER
JOIN table2
ON table2.something = table1.something
SET table2.field2 = table1.user
network18
Practically a Master Poster
629 posts since Sep 2009
Reputation Points: 29
Solved Threads: 76
Skill Endorsements: 0
futhonguy
Junior Poster in Training
69 posts since Oct 2009
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0
Question Answered as of 3 Years Ago by
network18