[rt-users] Deleting tickets 2
Vivek Khera
khera at kcilink.com
Mon Aug 6 10:17:00 EDT 2001
>>>>> "SP" == Steve Poirier <steve at inet-technologies.com> writes:
SP> Thanks! So, what i need to do is:
SP> select id from Tickets where Status='dead';
SP> You delete the Tickets where status is dead
Wow... pretty complex. Foreign keys would make this much easier.
Just declare a foreign key with ON DELETE CASCADE on the tables that
link back to ticket ID, then deleting the ticket ID in that table
would cascade the delete across to the other tables. I guess this
wouldn't work in MySQL, though...
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera at kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
More information about the rt-users
mailing list