On Wed, 2011-02-09 at 08:32 -0500, Chris Nelson wrote: > Roger Oberholtzer wrote: > >... > >> If you open the Trac database (which will depend on various > >> installation-specific settings), you can do: > >> > >> DELETE FROM subtickets WHERE parent=child; > > > > You make it look so simple. I really need to improve my SQL skills. > > I can never remember the commands. I Googled "sql delete" and got to > http://www.w3schools.com/sql/sql_delete.asp. While meta commands differ > a great deal from DBMS to DBMS, the basic SQL (INSERT, UPDATE, DELETE) > is remarkably stable. > > > > I am guessing I can do this via the sqlite3 command? I am never sure > > about the BEGIN TRANSACTION / COMMIT stuff. Do I need to put that > > around the DELETE statement? > > Transactions come into play when you have multiple commands that have to > take effect atomically (all of them or none of them). Since this is > only one command, you shouldn't need that overhead.
I will try this on a copy. How bad could it get? > > (Despite these questions, I am a C/Tcl/ASM/etc. programmer. Just not > > so familiar with SQL.) > > So you're the other Tcl programmer! ;-) > (http://www.amazon.com/dp/0072120045) Seems so. We use it in some interesting places. Overall we like it. But I confess to glancing at python and pyqt. But still faithful to tcl. -- Roger Oberholtzer -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
