<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Aw, c'mon Nancy, I always backup before doing anything. And I'm only toying around on a 'test' copy on the server, anyway.<div><br></div><div>I'm a sysadmin and reluctant web designer. Not a programmer or php/mysql guru. I think I understand separate INSERT statements. But there are so many doors I could unlock with this magic key....</div><div><br></div><div>JK. But it would be useful. And none of the basic tutorials seem to cover this.</div><div><br></div><div>Besides, you have no idea how slow and flaky (not to mention expensive) my internet connection is. It will take me at least 2 hours to do them individually through Drupal. An hour, probably, if I do each INSERT manually. And 10 minutes if I can batch them.</div><div><br></div><div>My ignorance notwithstanding: is there actually a problem with just mass updating the term_node table? I can't see that any other tables relate to that directly?</div><div><br></div><div><br></div><div><br><div><div>On 01 Nov 2011, at 7:16 PM, Ms. Nancy Wichmann wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:12pt"><div><span>If you must do it manually, you are safer doing separate INSERT statements.</span></div><div><br><span></span></div><div><span>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.</span></div><div> </div><div><font color="#ff007f" face="bookman old style, new york, times, serif" size="4"><i><strong>Nancy</strong></i></font></div> <div><font face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</font></div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> Jeff Brown <<a href="mailto:jeff@wildcoast.com">jeff@wildcoast.com</a>><br><b><span style="font-weight: bold;">To:</span></b> <a href="mailto:support@drupal.org">support@drupal.org</a><br><b><span style="font-weight: bold;">Sent:</span></b> Tuesday, November 1, 2011 11:33 AM<br><b><span style="font-weight: bold;">Subject:</span></b> [support] MySQL noob: Update images to gallery tid<br></font><br> Hope you'll pardon my absolute lack of knowledge of SQL and give me a <br>little clue or 2.<br><br>I'm retroactively changing the photos layout on a site to Views <br>Gallery, and need to update a couple of image nodes to the Term <br>"gallery".<br><br>Could do it manually, I guess, but I'd really love to know this trick.<br><br>So I have nid 1,2,3,4, etc. that need to have the gallery tid = <br>'1' (for argument's sake).<br><br>Therefore I need to update the 'term_node' table - and INSERT where <br>nid = 1,2,3,4 tid = '1'<br><br>I think that makes sense?<br><br>Thanks. :)<br>-- <br>[ Drupal support list | <a href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]<br><br><br></div></div></blockquote></div></div></div>-- <br>[ Drupal support list | <a href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]</blockquote></div><br><div> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div><div><font class="Apple-style-span" face="Courier">--</font></div><div><font class="Apple-style-span" face="Courier">Jeff Brown</font></div><div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">Tel:+27-74-101 5170</font></div><div><font class="Apple-style-span" face="Courier">Fax:+27-86-532 3508</font></div><div><font class="Apple-style-span" face="Courier"><a href="http://www.wildcoast.co.za/">www.wildcoast.co.za</a></font></div><div><font class="Apple-style-span" face="Courier"><br></font></div></div></div></div></span></div></span><br class="Apple-interchange-newline"> </div><br></div></body></html>