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@wildcoast.com To: support@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/ ]