于 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/


Reply via email to