Beefy Boxes and Bandwidth Generously Provided by pair Networks Cowboy Neal with Hat
P is for Practical
 
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 studying the Monastery: (6)
As of 2014-04-20 08:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (485 votes), past polls