We're a community of 1076K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,075,820 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

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

2
Contributors
2
Replies
17 Hours
Discussion Span
3 Years Ago
Last Updated
3
Views
Question
Answered
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

Thanks.. it works!!

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

This question has already been solved: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.0776 seconds using 2.72MB