[support] MySQL noob: Update images to gallery tid

[Jeff Brown]

That was badly phrased at the end. I meant: I think that makes sense,  
but I can't figure out the syntax.

Any pointers gratefully appreciated.

On 01 Nov 2011, at 5:33 PM, Jeff Brown wrote:

> 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/6c2e9259/attachment.html