perl - how to compare two cursors in mysql -
in db , have compare data between 2 cursors.
steps:
in cursor 1, write select query
(a huge select query) compares many tables , creates file , stores resultant data in table .
on other date, if run same cursor1 , there more rows added , there differenece in number of rows.
lets assume cursor 2 row table written cursor1 .
now want compare difference every day , comparing cursor1 cursor2.obviously , there difference , has written in file.
hope iam clear in explaining stuff. iam unable paste cursor it's above 300 lines , has 3 different queries in it.and compare first query data
ex :
cursor 1 = ( 'query1' = qq{} 'query2' = qq {} 'query3' = qq{} );
and compare first query new cursor 2 , want directly done in perl script have , not pl-sql or stored procedures.
thank you
Comments
Post a Comment