Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

Ovid (2709)

Ovid
  (email not shown publicly)
http://publius-ovidius.livejournal.com/
AOL IM: ovidperl (Add Buddy, Send Message)

Stuff with the Perl Foundation. A couple of patches in the Perl core. A few CPAN modules. That about sums it up.

Journal of Ovid (2709)

Friday February 09, 2007
05:32 AM

MySQL Tables Altered?

[ #32357 ]

Anyone happen to know, offhand, how I can check to see if any table in MySQL has been altered? This is MySQL 4.1.15. Obviously "SELECT count(*) ..." could fail as could checking which keys are present in a given table. Something as simple as an UPDATE statement can easily foil both of those checks. I've tried 'SHOW STATUS ...', but that also fails. The only thing I can think of is to use a DBI trace to capture SQL and look for INSERT, UPDATE, or DELETE statements and try and parse them for the appropriate tables.

Google's given me no love on this problem.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.