Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

•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 browsing the Monastery: (8)
As of 2017-09-26 07:38 GMT
Find Nodes?
    Voting Booth?
    During the recent solar eclipse, I:

    Results (292 votes). Check out past polls.