于 2010-10-18 11:42, Jason Feng 写道:
Hello,
I am using
Perl and MySQL to maintain a database of mobile network configuration about 30
tables and millions of rows. Every day, I’ll be importing new configuration
data to the database.
I’d like to create a delta report on which row and which
column are modified, which row is deleted, which row is added. It will be
time-consuming if just comparing each row and column one by one of today's data
and yesterday's data.
This is most likely a mysql question
You may enable the binary log (AKA mysql-bin log) for mysqld then get
the statistics from it.
--
Jeff Peng
http://nsbeta.info
--
To unsubscribe, e-mail: beginners-unsubscr...@perl.org
For additional commands, e-mail: beginners-h...@perl.org
http://learn.perl.org/