[rt-users] Remove a ticket

[Alberto Villanueva]

Hi all,

 

I would to remove all tickets, but I don't remove the whole database. Does
someone know which the best manner to do that?

 

I have a solution, but I don't know if it's the best:

 

mysql -p

<password>

use <database>

delete * from Transactions;

delete * from Tickets;

 

 

Regards,


ALBERTO VILLANUEVA VAL 

Consultor

____________________________________________

Altran

 

ParqueEmpresarial Las Mercedes, Edificio 1 
C/ Campezo, 1. 28022 Madrid
Tel : + 34 91 744 46 00
Fax: + 34 91 415 24 57

 <http://www.altran.es> www.altran.es

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090217/8caf6b3f/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3874 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20090217/8caf6b3f/attachment.jpg>