{"id":105,"date":"2010-10-05T17:41:53","date_gmt":"2010-10-05T16:41:53","guid":{"rendered":"https:\/\/ridgesolutions.ie\/?p=105"},"modified":"2010-10-05T19:28:04","modified_gmt":"2010-10-05T18:28:04","slug":"swapping-database-column-values-mysql","status":"publish","type":"post","link":"https:\/\/www.ridgesolutions.ie\/index.php\/2010\/10\/05\/swapping-database-column-values-mysql\/","title":{"rendered":"Swapping Database Column Values (mySQL)"},"content":{"rendered":"

Software Developers know their away around SQL – it is a tool of the trade (as it were!), however today I had to revert to google<\/a> to find the SQL to swap the values of 2 columns within a table. Luckily I found this<\/a> interesting (and very handy) article that explains just how to do it:<\/p>\n

 <\/p>\n

http:\/\/beerpla.net\/2009\/02\/17\/swapping-column-values-in-mysql\/<\/a><\/p>\n

 <\/p>\n

I had to reverse the relationships between drupal <\/a> taxonomy terms, this was to be done by reversing the values of the tid1 and tid2 columns of the term_relation table, this code did the trick for me:<\/p>\n

 <\/p>\n

[code]
\nUPDATE term_relation SET tid1=tid2, tid2=@temp WHERE (@temp:=tid1) IS NOT NULL;
\n[\/code]<\/p>\n

 <\/p>\n

If I had to manually reverse all of the taxonomy relationships via the drupal admin interface it would have taken _forever_!<\/p>\n

 <\/p>\n

PS. If, for a given taxonomy term id, you need to get a list of the related taxonomy terms, just call:
\n[code]taxonomy_get_related()[\/code] although be warned that the concept of related terms is to be removed in drupal 7!<\/p>\n","protected":false},"excerpt":{"rendered":"

Software Developers know their away around SQL – it is a tool of the trade (as it were!), however today I had to revert to google to find the SQL to swap the values of 2 columns within a table. Luckily I found this interesting (and very handy) article that explains just how to do […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[21,109],"class_list":["post-105","post","type-post","status-publish","format-standard","hentry","category-tech-stuff","tag-drupal","tag-mysql"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t