Follow-up: If you're deleting tickets because they contain spam, you may also have to delete comments and changes which are in the ticket_change table. You can select records using the keyword 'rowid', e.g. delete from ticket_change where rowid > 100;
You can also follow the thread below to learn how to determine the column names in a sqlite table, and then delete records based on one of those columns: http://marc.10east.com/?l=sqlite-users&m=109355707304101&w=2 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
