[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