[support] MySQL noob: Update images to gallery tid

[Ms. Nancy Wichmann]

If you must do it manually, you are safer doing separate INSERT statements.

But, since you say you are unfamiliar with the Drupal database, I strongly recommend doing it through the Drupal user interface to avoid damaging your database.

 
Nancy 
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.



>________________________________
>From: Jeff Brown <jeff at wildcoast.com>
>To: support at drupal.org
>Sent: Tuesday, November 1, 2011 11:33 AM
>Subject: [support] MySQL noob: Update images to gallery tid
>
>Hope you'll pardon my absolute lack of knowledge of SQL and give me a  
>little clue or 2.
>
>I'm retroactively changing the photos layout on a site to Views  
>Gallery, and need to update a couple of image nodes to the Term  
>"gallery".
>
>Could do it manually, I guess, but I'd really love to know this trick.
>
>So I have nid 1,2,3,4, etc. that need to have the gallery tid =  
>'1' (for argument's sake).
>
>Therefore I need to update the 'term_node' table - and INSERT where  
>nid = 1,2,3,4 tid = '1'
>
>I think that makes sense?
>
>Thanks. :)
>-- 
>[ Drupal support list | http://lists.drupal.org/ ]
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20111101/a0044bb7/attachment.html