[support] MySQL noob: Update images to gallery tid

Jeff Brown jeff at wildcoast.com
Tue Nov 1 15:33:15 UTC 2011


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. :)


More information about the support mailing list