Your Ad Here

advanced code snippet search

Posted By

berkes on 01/08/10


Tagged

database tags drupal taxonomy


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

MikeyLikesIt


move Drupal tags from one vocabulary into another

 / Published in: SQL
 

I had several vocabularies but wanted to merge them into one. A simple query does this for you.

The vocabularyid where I wanted to merge all the tags into is 3 The vocabularyid where the tags are to be merged from is 7, 8 and 12

Expand | Embed | Plain Text 
  1. UPDATE term_data SET vid = 3 WHERE vid IN(7, 8, 12)

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: ReeceMarsland on January 8, 2010

Nice, you can also achieve this with: http://drupal.org/project/taxonomy_manager :-D

Posted By: berkes on January 15, 2010

Thanks for the link. I was aware of that module, but often, one-time-actions are simpler to achieve with a database migration (e.g. in hookupodateN) than with a new module.

You need to login to post a comment.