Advanced Search

Return to Snippet

Revision: 22297
at January 8, 2010 04:41 by berkes
Initial Code 
UPDATE term_data SET vid = 3 WHERE vid IN(7, 8, 12)
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

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

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

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
move Drupal tags from one vocabulary into another

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
database, drupal

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL