Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

•Re: Cleanup ALerts in Snort/ACID Mysql DB

by merlyn (Sage)
on Apr 03, 2003 at 23:10 UTC ( #247927=note: print w/ replies, xml ) Need Help??


in reply to Cleanup ALerts in Snort/ACID Mysql DB

Wow. Too bad MySQL doesn't have foreign keys with ON DELETE CASCADE support, like PostgreSQL has had for a few years already.

Would be a great time saver. Might be easier just to install PostgreSQL.

-- Randal L. Schwartz, Perl hacker
Be sure to read my standard disclaimer if this is a reply.


Comment on •Re: Cleanup ALerts in Snort/ACID Mysql DB
Re: •Re: Cleanup ALerts in Snort/ACID Mysql DB
by tunaboy (Curate) on Apr 04, 2003 at 06:31 UTC

    I don't want to start up a PostgreSQL vs MySQL debate (as it is comparing apples and oranges) but if you make use of InnoDB tables then you can specify foreign keys and cascading deletes.

    MySQL Documentation

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://247927]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (12)
As of 2014-08-28 16:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (265 votes), past polls