Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
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: (8)
As of 2014-12-21 22:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (108 votes), past polls