Community

Copying field contents from one table to another

I need some help / advise / guidance. i am a very basic user.

I would like to copy the contents of a certain field in one table to another within my Drupal database.

The structure of the two tables are different, but both tables share the same list of node IDs (nid).

One table is the node_revisions table, and the other is a content_field_description table.

By some mistake in the past, i had created the content_field_description field to contain the main body of the node content. now, as i try to clean things up, I want to move those content in the content_field_description into the node_revisions table. I only want to move the content in only one field between the two tables.

how do i do this? thanks in advance.

Comments

any help?

any help? please?

_

Instead of mucking around in the db, you could do it with views_bulk_operations-- i use it for moving data between fields all the time and it works great.

_
Don't be a Help Vampire - read and abide the forum guidelines.
If you find my assistance useful, please pay it forward to your fellow drupalers.

thanks. will try

@WorldFallz - thanks for that. i will check it out.