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

TheFazz’s picture

any help? please?

WorldFallz’s picture

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.

TheFazz’s picture

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