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

Popular posts from this blog

android - getbluetoothservice() called with no bluetoothmanagercallback -

sql - ASP.NET SqlDataSource, like on SelectCommand -

ios - Undefined symbols for architecture armv7: "_OBJC_CLASS_$_SSZipArchive" -