Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic

•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

Replies are listed 'Best First'.
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?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://247927]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (5)
As of 2017-11-21 21:38 GMT
Find Nodes?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:

    Results (312 votes). Check out past polls.