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/ ]