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

Recommended Answers

All 2 Replies

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

Thanks.. it works!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.